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?

Remove value of "0" from blank Excel cell
//192.168.l.0 - Guide
Code to remove number from blacklist - Guide
How to remove number from blacklist - Guide
Excel marksheet - Guide
Number to words in excel - Guide

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)

Similar discussions

,">"&0),"") at the end of a countif formula

Can't remove threat with Windows Defender

Ig stories from close friends to public

Call barring cancel code

Similar discussions

Subscribe To Our Newsletter!