I have a list of states in column A with corresponding data in column B (everything is text). I am trying to highlight both column A and column B based on which state is listed in column A.
In other words, every row for both columns where Florida is listed in Column A, I want to highlight. I know I will need a separate rule for each state but just can't seem to find a way to get column B highlighted.
Bookmarks