Format/ Conditional Formatting/ Formula is/ =WEEKDAY(B1,2)=6
and set your grey shading.
--
David Biddulph

"michaelberrier" wrote in message
ups.com...
Column A has dates; Column B has days of the week which come from
Column A. In other words, in B1 it says "=A1" and is formatted to
give me the day instead of the date.

How can I use conditional formatting to shade B1 gray based on the
DAY, not the date, that shows up if it is a weekend?

Thanks,