Formatting an empty cell

[PaulJ]

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

 

[Darvishan]

Have you tried using the 'Highlighted Cell Rules' - 'Between'?
make your left entry 0.00001 to 80
?

 

[Alex Blakenburg]

Sure
=A$2=""
with Stop if True
works fine for me.
Alternatively
=AND(A$2<80,A$2<>"")

 

[PaulJ]

Sure
=A$2=""
with Stop if True
works fine for me.
Alternatively
=AND(A$2<80,A$2<>"")

Thanks very much for that. Works a treat.

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.