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...
I recommend adding a rule to check for blank, make it the first rule, and check 'stop if true'.
This is the idea: