Forum Discussion
molly1895
Sep 04, 2024Copper Contributor
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.
- Patrick2788Silver Contributor
I recommend adding a rule to check for blank, make it the first rule, and check 'stop if true'.
This is the idea: