Hi everyone,
I am working on a document with some conditional formatting to add some colour coding.
It's all going ok, except that I need for rows with overdue responses (column k) to be highlighted in red.
It ends up highlighting all the rows which are also blank.
When I use format only cells that contain blanks - no formatting, it whites out all the colour except for a few seemingly random boxes covered by other conditions - no matter how I fiddle with the order.
Can anyone offer any help with this?
Document attached - highlighted all in red like crazy XD
Also, would there be a way to highlight the rows using a vba macro instead? Would that be more or less effective/prone to error than conditional formatting?
Bookmarks