Hi there

I'm hoping someone can assist me. I am wanting a range of cells shaded grey,
one of which includes a formula that specifies its date, and if the date
falls on a Saturday and Sunday they're to be shaded grey. Some more
information that may help. The workbook contains 4 sheets, one for each
quarter, and for each quarter I want to just have to enter one date i.e
01/03/2009 formatted to 1-Mar-09, the rest of the date specific columns
across the sheet are populated by & simple '=c3+1' formula but then if that
date is a Saturday and Sunday, I'd like it and several rows below it, shaded
grey.

Hope this makes sense.
Cheers,
Champ