Forum Discussion
Conditional formatting a column or array if cell contains text
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.
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.
