Blank Cells - conditioning format
 

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!


--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: http://www.excelforum.com/member.php...o&userid=34133
View this thread: http://www.excelforum.com/showthread...hreadid=540311

Blank Cells - conditioning format
 

Sean,

Formula is:

=A1=""

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540311

Blank Cells - conditioning format
 

A1=""

A1<""


something like that?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"seanrigby" wrote
in message ...

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!


--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile:
http://www.excelforum.com/member.php...o&userid=34133
View this thread: http://www.excelforum.com/showthread...hreadid=540311

Blank Cells - conditioning format
 

"seanrigby" wrote
in message ...

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.

=ISBLANK(A1)
--
David Biddulph

Blank Cells - conditioning format
 

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540311

Blank Cells - conditioning format
 

Thanks Steve!


--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: http://www.excelforum.com/member.php...o&userid=34133
View this thread: http://www.excelforum.com/showthread...hreadid=540311