View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=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