PaulJ
Board Regular
- Joined
- Dec 19, 2011
- Messages
- 71
- Office Version
- 365
I'm using conditional formatting to format cells with a value less than 80 to make them red for quick identification. This works so any value less the 80 becomes red.
However, blank/empty cells are also turning red (which I don't want). Is there a formula that identifies an empty cell and I could than use "Stop if True" so it stop before looking for cells with less than 80?
Thanks in advance for your help.
Regards
However, blank/empty cells are also turning red (which I don't want). Is there a formula that identifies an empty cell and I could than use "Stop if True" so it stop before looking for cells with less than 80?
Thanks in advance for your help.
Regards