Counting and colour coding ranges of occurances
You can use conditional formatting using these formulas for the three
conditions.
=AND(COUNTIF($A$1:$A$30,A1)5,COUNTIF($A$1:$A$30,A 1)<11)
=AND(COUNTIF($A$1:$A$30,A1)10,COUNTIF($A$1:$A$30, A1)<16)
=COUNTIF($A$1:$A$30,A1)15
Regards,
Alan.
"ConfusedinCalgary" wrote in
message ...
a have a list of employee ID numbers and need to count how many times they
occur withing certain ranges. For example: if one occurs between 5-10
times
I want all occurances highlighted in yellow, if it occurs between 10-15
times
I want all occurances highlighted in blue, and if it occurs more than 15
times I want all occurances highlighted in red. Any suggestions?
|