Automatically change colour of column underneath given text

[StuckWithExcel]

Hi,
I would like to make every column under "Sat" and "Sun" to appear as grey (for sake of argument call it Hex #D9D9D9).
How would I go about this?
Thanks.

 

[Sufiyan97]

Try in conditional formatting, change cell to your starting cell.

=OR(B$1="Sat",B$1="Sun")

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1		Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B:S	Expression	=OR(B$1="Sat",B$1="Sun")	text	NO