Formatconditional formatting, formula is and use

=WEEKDAY(A1,2)5

click format and select patterns

click OK twice

where A1 is the cell you want to format

Regards,

Peo Sjoblom

"Justin" wrote:

I have cells that have a formula that displays the day of the week based on a
date elsewhere. I would like to shade a portion of the saturday and sunday
columns and have it update automatically when the month changes. I need a
pretty descriptive answer as I am still learning the ways of Excel. Please
help as soon as you can.

Thank you