View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Calendar Holiday question

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))