ExcelBanter - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional Formatting (https://www.excelbanter.com/excel-worksheet-functions/131535-conditional-formatting.html)

2442

Conditional Formatting

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

Elkar

Conditional Formatting

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"?

2442

Conditional Formatting

Thank you very much Elkar.

"Elkar" wrote:

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"?

All times are GMT +1. The time now is 07:01 PM.