Blank Cells - conditioning format

S

seanrigby

Trying to make a conditioning format formula to detect when the cell is
blank. I would use "=0" but the cells will have number imputs and
sometimes they would be zero.

Any help would be appreciated.

Thanks!
 
D

David Biddulph

seanrigby said:
Trying to make a conditioning format formula to detect when the cell is
blank. I would use "=0" but the cells will have number imputs and
sometimes they would be zero.
Click to expand...

=ISBLANK(A1)
 
S

SteveG

Sean,

If you are just inputting the numbers the =ISBLANK(A1) is fine but
A1 will not format if there is a formula in A1 even if the cell appears
blank as a result of the formula.

HTH

Steve
 
Top