Conditional format column based on header

[grimmreaper]

Good day


Basically I want to fill the color of the column if the heading is Saturday or sunday. That is step one.


Step two is I want to have the average of each day.

	mon	tues	wed	thurs	fri	sat	sun	mon	average	monday	tues	wed
	1 July	2 July	3 July	4 July	5 july	6 july	7 july	8 july
0am til 1am	1	2	5	0	9	5	1	11
1am until 2am	7	7	8	6	1	7	8	8
etc.

<tbody>
</tbody>

 

[grimmreaper]

Just an update.

I have been able to complete the second step on my own

 

[steve the fish]

Where it says Mon 1 July is that in one cell? How do we know which year that is?

 

[steve the fish]

Ah ive read it again. Try this conditional formatting formula:

=OR(B$1="sat",B$1="sun")

Apply it to =$B:$I

 

[grimmreaper]

Ah ive read it again. Try this conditional formatting formula:

=OR(B$1="sat",B$1="sun")

Apply it to =$B:$I

Works like a charm thank you