Need a formula for Conditional Formatting

[VICTOR5]

Hi to all,

I need a formula for conditional formatting like that : if I change a date so according to date the column of day should be highlight.

thanks......

[KiPA]

Cell Value Is equal to =TEXT($C$2-1;"dddd")

Just to make sure: in the example you highlighted Saturday while 28-Nov-10 being Sunday. That ^ formula will give you solution for that. However if you meant to highlight the "accurate" day, should the formula be

=TEXT($C$2;"dddd")

[mahju]

Use extra cell e.g F1 and enter the formula
=weekday(C2)
It will display the day number of week
that is 1 for Sunday, 2 for Monday and ...... 7 for Saturday

Enter formula for conditional formatting in cell c3 (Contains Saturday)

=IF(F1=7, TRUE, FALSE)

In cell d3 (Sunday) enter
=IF(F1=1, TRUE, FALSE)

Similarly in E3 --> =IF(F1=2, TRUE, FALSE)

In F3 ---> =IF(F1=3, TRUE, FALSE)

In G3 ---> =IF(F1=4, TRUE, FALSE)

In H3 ---> =IF(F1=5, TRUE, FALSE)

In I3 ---> =IF(F1=6, TRUE, FALSE) and in

Note that all these formulas are to be entered in Conditional formatting Box

Menu --> Format --- Conditional Formatting

Enter the formula and format as required.

Regards
Mahju