=WEEKDAY(A1,2)5
will be true for Sat or Sun
--
HTH
Bob Phillips
"PaolaAndrea" wrote in message
...
I have a calendar and I want to change the color for the cell that are Sat
or
Sun. The date is a formula (=today()) and I want to have sat or sun come
up
with a different color, not only where the date is but also some lines
that
go down the line.
Please Help.
Sincerely,
PaolaAndrea
|