Remove value of "0" from blank Excel cell

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I need to set conditional formatting so if the number 0 - 999 is typed in a cell, the cell fill will be yellow. If the cell is blank, I need it blank. Excel seems to think that a blank cell = 0, how do I change this?


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
how about like this

=and(a1<>"", a1>=0, a1<=999)