Conditional formatting a column or array if cell contains text

Shoeball 

Let's say the day row is row #3.

Select A1:Z300. A1 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula  =OR($A3="Sat",$A3="Sun")

There is no $ before the column letter A because the column has to be adjusted dynamically.

There is a $ before the row number 3 because the formatting must depend on the cell in row 3 for ALL cells in the column.

Click Format...

Select the Fill tab.

Select a highlight color.

Click OK, then click OK again.