Conditional Formatting

Dear all,

I have simplified what I am trying to do but...

In Cell A1 I have a date in the dddd dd/mm/yy format

In Cell B1 I have a day of the week in TEXT format

What I want to do is conditionally format A1 if the day differs from day (not date) of that in B1.

I have searched for the right formula all over but without luck.

Any help would be great.

Thanks, Crackerdaq

I'd go with something like:

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

In column C
This will display the day of the week in text, according to the date in column A.

You could then use something like:

=IF(C1<>B1,"*","")

in column D, and set the conditional format to read if the cell in D is * then <whatever>.

mew?