Conditional formatting

[Sandy]

Condition:- If cell C48 is not blank AND cell C49 is blank then colour cell
C49 light yellow.

I have placed the following in condition 1 for Cell C49

=AND(NOT(ISBLANK(C48)),ISBLANK(C49))

however the cell colour changes to light yellow when C48 is blank and C49 is
blank.
Where am I going wrong?

Sandy

 

[Pete_UK]

Are you sure that C48 is really blank? Enter this formula somewhere:

=LEN(C48)

and it should return 0 if the cell is empty (you might have one or
more spaces in there which look blank).

Another way of trying this is:

=AND(C48<>"",C49="")

Hope this helps.

Pete

 

[Sandy]

Hi Pete

=LEN(C48) placed elsewhere shows 0

However using your formula =AND(C48<>"",C49="") produces the desired
results!

On thinking about this again there is a formula in C48 so I presume that had
a bearing on things??

Thanks Pete
Sandy

 

[Pete_UK]

Glad to hear that, Sandy - thanks for feeding back.

Personally, I avoid using ISBLANK, as its results can be a bit
confusing.

Pete

 

[Sandy Mann]

On thinking about this again there is a formula in C48 so I presume that

had a bearing on things??

By definition if C48 has a formula in it then it can't be blank so ISBLANK()
will alwayts return FALSE

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk