I want to make a conditional format that will leave the cell unchanged if the
cell involved is blank.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks