How do you know which month? For the sake of argument, let's say it is in
A2, then you can use conditional formatting on the cells A1:AE1 with a
formula of

=WEEKDAY(A1,2)5

then just format to suit.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Unicornlmb" wrote in message
...
I have a worksheet with the dates 1 to 31 across the top of the page for
the
12 months of the year, is there a way to have excel hilight or colour code
Saturdays and Sundays on each worksheet automaitcally?