How do I shade cells that are below Sat or Sun in a calender?
 

I am setting up a calender in excel and I would like to shade the cells that
are below each Saturday and Sunday.
I have listed the dates from cell B1 to AD1 and I have a list of to do items
in A2 to A10. As the tasks are not to be completed on the weekend, I wanted
to be able to shade in these cells.

Thanks

How do I shade cells that are below Sat or Sun in a calender?
 

Select cells B2:AD10
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type:
=OR(WEEKDAY(B$1)=1,WEEKDAY(B$1)=7)
where cell B2 is the active cell (you'll see B2 in the Name Box, at the
left of the Formula Bar)
Click the Format button, and on the Patterns tab, select the shading
that you want.
Click OK, OK.

Mike wrote:
I am setting up a calender in excel and I would like to shade the cells that
are below each Saturday and Sunday.
I have listed the dates from cell B1 to AD1 and I have a list of to do items
in A2 to A10. As the tasks are not to be completed on the weekend, I wanted
to be able to shade in these cells.

Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

How do I shade cells that are below Sat or Sun in a calender?
 

Your a star!! Thanks.

"Debra Dalgleish" wrote:

Select cells B2:AD10
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type:
=OR(WEEKDAY(B$1)=1,WEEKDAY(B$1)=7)
where cell B2 is the active cell (you'll see B2 in the Name Box, at the
left of the Formula Bar)
Click the Format button, and on the Patterns tab, select the shading
that you want.
Click OK, OK.

Mike wrote:
I am setting up a calender in excel and I would like to shade the cells that
are below each Saturday and Sunday.
I have listed the dates from cell B1 to AD1 and I have a list of to do items
in A2 to A10. As the tasks are not to be completed on the weekend, I wanted
to be able to shade in these cells.

Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

How do I shade cells that are below Sat or Sun in a calender?
 

You're welcome! Thanks for letting me know that it helped.

Mike wrote:
Your a star!! Thanks.

"Debra Dalgleish" wrote:


Select cells B2:AD10
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type:
=OR(WEEKDAY(B$1)=1,WEEKDAY(B$1)=7)
where cell B2 is the active cell (you'll see B2 in the Name Box, at the
left of the Formula Bar)
Click the Format button, and on the Patterns tab, select the shading
that you want.
Click OK, OK.

Mike wrote:

I am setting up a calender in excel and I would like to shade the cells that
are below each Saturday and Sunday.
I have listed the dates from cell B1 to AD1 and I have a list of to do items
in A2 to A10. As the tasks are not to be completed on the weekend, I wanted
to be able to shade in these cells.

Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html