Conditional Formatting A Row
 

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.

Conditional Formatting A Row
 

hi
select cell A9 then
on the menu bar...
formatsconditional 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
formats.

Regards
FSt1

"Allen" wrote:

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.