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

K

Kman

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

Toppers

Probably use an IF/AND condition

Something like:

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

HTH
 
P

Peo Sjoblom

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
 
Top