Forum Discussion
Conditional formatting but ignore blanks
I am trying to use conditional formatting to highlight a cell when its value is less than the cell directly above it, but ignore the formula if the cell is blank. Right now it treating blank cells as zero, so the last entry is always highlighted.
1 Reply
I recommend adding a rule to check for blank, make it the first rule, and check 'stop if true'.
This is the idea:
