software

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?


Try:

=OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7)HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498354How 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)gt;5

then just format to suit.

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Unicornlmbquot; gt; wrote in message
...
gt; I have a worksheet with the dates 1 to 31 across the top of the page for
the
gt; 12 months of the year, is there a way to have excel hilight or colour code
gt; Saturdays and Sundays on each worksheet automaitcally?