View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default 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