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.
|