View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
 
Posts: 199
Default Highlighting weekends in a calendar

"Bill L" wrote in message
...
I have a calendar with the weekdays accross the top and I want to be able
to
change the days accross the top month to month and have Saturday and
Sunday
Highlight in the columns below the weekend.


Suggest you use conditional formatting based on WEEKDAY(cell ref) = 1
(Sunday) or 7 (Saturday).

V