View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Allen Allen is offline
external usenet poster
 
Posts: 50
Default 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.