Highlighting weekends in a calendar

  • Thread starter Thread starter Bill L
  • Start date Start date
B

Bill L

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.
 
Bill L said:
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.
Click to expand...

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

V
 
Victor Delta said:
Suggest you use conditional formatting based on WEEKDAY(cell ref) = 1
(Sunday) or 7 (Saturday).

V

V,
Click to expand...
I must be doing somthing wrong, I entered
formula=weekday(c2:ag10)=1(Su)or7(Sa) and format color as the light yellow.
The days are in row 2, what I want each month is to be able to change days in
row 2 Su,Mo,Tu, etc. as to the month I'm in, and have the colums highlight
yellow below to display weekends for easily reference.
 
Back
Top