Remove value of "0" from blank Excel cell

Closed
TDB - May 15, 2010 at 10:26 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 15, 2010 at 10:56 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 15, 2010 at 10:56 AM
how about like this

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