Conditional Formatting

[2442]

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

 

[Elkar]

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]

Thank you very much Elkar.

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