I have a Text value in $O$2. I have no blanks. I want to format each row based on the text value found it the O column. from A-O.
I've got these setup for conditional formatting, but they're only working on the first row (after the headers so Row 2 technically)
conditional formatting rules.PNG
Bookmarks