Select cell K3 through K200
From the Format Menu, select "Conditional Formatting..."
Change "Cell Value Is" to "Formula Is"
Enter the formula: =OR($K$1="Sat",$K$1="Sun")
Select your format
Click OK

HTH,
Elkar


"2442" wrote:

How can I shade cells K3:K200 if cell K1 equals "Sat" or "Sun"?