Highlighting weekends in a calendar

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.
 
V

Victor Delta

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.

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

V
 
B

Bill L

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

V

V,
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top