A couple of ways and here's one.

Select your cell

format|conditional formatting|cell value is| equal to

="Sat"

set your colour

and add a second condition for Sun

Mike

"michaelberrier" wrote:

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,