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