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

Wed	Thu	Fri
Jim	Jim	Jim
Anna	Anna	Anna
Steve	Steve
Frank	Frank
Graham

<colgroup><col span="3"></colgroup><tbody>
</tbody>

 

[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