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.

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.