Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |