How can I refer to a blank cell when using conditional formating?
 

I want to make a conditional format that will leave the cell unchanged if the
cell involved is blank.

How can I refer to a blank cell when using conditional formating?
 

Probably use an IF/AND condition

Something like:

Formula is: =IF(AND(A1<"",A1=condition))

HTH

"Kman" wrote:

I want to make a conditional format that will leave the cell unchanged if the
cell involved is blank.

How can I refer to a blank cell when using conditional formating?
 

If using conditional formatting testing for a non blank cell to this would
suffice

=A1<""

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Toppers" wrote in message
...
Probably use an IF/AND condition

Something like:

Formula is: =IF(AND(A1<"",A1=condition))

HTH

"Kman" wrote:

I want to make a conditional format that will leave the cell unchanged if
the
cell involved is blank.