1 reply to this topic

[b00g3R]

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.

[Scythar]

think what you mean is called "conditional format" (actually dunno the english translation), after selecting the cells you want in that format.
You can make up several for one "range" (f.ex. >7 = red; 0-7 = blue, negative = green r something)

 VoorwOpmaak2.jpg   27.68KB   33 downloads
 VoorwOpmaak1.jpg   56.19KB   55 downloads

Edited by Scythar, 17 March 2008 - 04:37 PM.