software

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

Any help would be appreciated.

Thanks!--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: www.excelforum.com/member.php...oamp;userid=34133
View this thread: www.excelforum.com/showthread...hreadid=540311
Sean,

Formula is:

=A1=quot;quot;

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=540311A1=quot;quot;

A1lt;gt;quot;quot;something like that?--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;seanrigbyquot; gt; wrote
in message ...
gt;
gt; Trying to make a conditioning format formula to detect when the cell is
gt; blank. I would use quot;=0quot; but the cells will have number imputs and
gt; sometimes they would be zero.
gt;
gt; Any help would be appreciated.
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; seanrigby
gt; ------------------------------------------------------------------------
gt; seanrigby's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34133
gt; View this thread: www.excelforum.com/showthread...hreadid=540311
gt;
quot;seanrigbyquot; gt; wrote
in message ...
gt;
gt; Trying to make a conditioning format formula to detect when the cell is
gt; blank. I would use quot;=0quot; but the cells will have number imputs and
gt; sometimes they would be zero.

=ISBLANK(A1)
--
David Biddulph

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: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=540311
Thanks Steve!--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: www.excelforum.com/member.php...oamp;userid=34133
View this thread: www.excelforum.com/showthread...hreadid=540311