Calendar Help

[Alvin43047]

Hi everyone, I am looking for help in creating a calendar for work I would like to get the following cells formatted so if there are 5 names the cells all colour red, 3 or 4 they colour yellow and 1 or 2 they colour green. Does anyone know if this is possible?.
Thanks in advance
Regards
Alvin


[TABLE="width: 192"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jim [/TD]
[TD]Jim [/TD]
[TD]Jim [/TD]
[/TR]
[TR]
[TD]Anna[/TD]
[TD]Anna[/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]Steve[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Frank[/TD]
[TD]Frank[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Graham[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Richard U]

Yes, for each range, create a set of conditional formats using the COUNTA function

=Counta(RANGE) <3 green
= counta(RANGE) <2 and counta(RANGE) <5 yellow
=Counta(RANGE) =5 green

You can set the conditional formatting on the HOME tab