I have created a calendar that will shade out the weekends. I would like it
to have a different shade (for holiday's) - with possibly an "H" in the cell.

In the cells for the other workday's I will be leaving blank - or putting in
the number of hours - I'm taking off -- this last piece I have working as
well.

Any suggestions on how to automate the shading (with the possibility of an
"H" in the appropriate days cell(s))

If "H" is in a cell(s) then use Conditional Formatting to shade

Select range for formatting then

Format==Conditional formatting==Cell value is : Equal to: ="H" , set
colour, OK

HTH

"Brad" wrote:

I have created a calendar that will shade out the weekends. I would like it
to have a different shade (for holiday's) - with possibly an "H" in the cell.

In the cells for the other workday's I will be leaving blank - or putting in
the number of hours - I'm taking off -- this last piece I have working as
well.

Any suggestions on how to automate the shading (with the possibility of an
"H" in the appropriate days cell(s))

Sorry - I wasn't specific enough - I want to have Excel take the list of
dates labelled as holiday (could be 8-15 dates) and put an "H" in the cell
and shade the cell. I want this to be repeatable process.

Additionally the cells will either be blank or have the number of hours
taken off for the particular day. Obviously, each year these "hours" would
have to be erased.

"Toppers" wrote:

If "H" is in a cell(s) then use Conditional Formatting to shade

Select range for formatting then

Format==Conditional formatting==Cell value is : Equal to: ="H" , set
colour, OK

HTH

"Brad" wrote:

I have created a calendar that will shade out the weekends. I would like it
to have a different shade (for holiday's) - with possibly an "H" in the cell.

In the cells for the other workday's I will be leaving blank - or putting in
the number of hours - I'm taking off -- this last piece I have working as
well.

Any suggestions on how to automate the shading (with the possibility of an
"H" in the appropriate days cell(s))

This equation below works - but when I try to substitute b7 for 39083 it
doesn't

=OR((DATE(2007,1,1)={39083,39097,39132,39267,39328 ,39356,39397,39408,39441}))

What do I have to do to the above equation to allow cell references - rather
than hardcoding the dates (in the list)?

I will want to check every day of the year against the list of numbers -
presented above

"Brad" wrote:

I have created a calendar that will shade out the weekends. I would like it
to have a different shade (for holiday's) - with possibly an "H" in the cell.

In the cells for the other workday's I will be leaving blank - or putting in
the number of hours - I'm taking off -- this last piece I have working as
well.

Any suggestions on how to automate the shading (with the possibility of an
"H" in the appropriate days cell(s))