I'm trying to achieve the following:
When value in column AG = FALSE, highlight entire corresponding row bright orange.
When value in column AG = TRUE, remove corresponding highlight from row
The easiest way to achieve this I think would be to use conditional formatting (using excel 2003)
My issue is that when false is entered into AG3 for example, all of row 3 is highlighted except for the cells which have text in it. I can't work out how to make sure the entire row is highlighted including text?
The formula I'm using is: =$3:$23="FALSE"
Can anyone help? See attachment for an example of my issue