Conditional Formatting A Row

A

Allen

I cant seem to figure this out.
Im not sure if it is a formula or a conditional or using both or maybe only
in VBA but not sure.
I want a row to change background color when a certain word is put in it.
not just the cell but the whole row in the table.

ex.
Table
A1 - O1
A19 - O19

Is filled with information.
In the "G" column I have information that has certain text.
When a certain text is inputted I want the row its in to change color.
So if say, "INFO" is in "G9" i want A9 - O9 to change background color.

So yeah, im not sure if that is even clear but let me know.
Im not sure what im suppose to do.
 
F

FSt1

hi
select cell A9 then
on the menu bar...
formats>conditional formats.
in the dialog box enter....
formula is........=if($G$9="info",1,0)......pick your color
note: the formula sets up a true/false condition concerning cell G9. if it
has "info" in it, then color the cell.
with the conditional format entered into A9, copy A9...
1. you can paste the conditional format from B9 to O9 regular ie with the
paste icon or Ctrl+V on the keyboard
2. you can paste the conditional format from B9 to O9 with paste special

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top