Previous Topic Next Topic

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?


Related:

1 response

Answer 1 / 1
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

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses
Can't remove threat with Windows Defender
Babarali4 -
ravida_1351 -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Call barring cancel code
Abubakkar -
dwebb -

1 response