28
I want the whole row to go red when one cell says overdue, and only that one cell changes colour — what is the rule?
A tracker with about eight columns. One of them holds a status, and I want the entire row highlighted when that status is overdue, so I can see it while scanning. I selected the range, added a conditional formatting…