If you have "Sunday" in A1,
Select the cells you want to be shaded (say A2:C10). Go to conditional
format, use "formula is" and enter
=$A$1="Sunday"
and choose format and select a grey color. Then if A1 says sunday, those
cells will take on that color.
"Justin" wrote in message
...
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
|