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.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]mon[/TD]
[TD]tues[/TD]
[TD]wed[/TD]
[TD]thurs[/TD]
[TD]fri[/TD]
[TD]sat[/TD]
[TD]sun[/TD]
[TD]mon[/TD]
[TD]average[/TD]
[TD]monday[/TD]
[TD]tues[/TD]
[TD]wed[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1 July[/TD]
[TD]2 July[/TD]
[TD]3 July[/TD]
[TD]4 July[/TD]
[TD]5 july[/TD]
[TD]6 july[/TD]
[TD]7 july[/TD]
[TD]8 july[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0am til 1am[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]9[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1am until 2am[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]etc.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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