The first formula should be:
=AND(COUNTIF(C:C,C1)>4,COUNTIF(C:C,C1)<11)
>4, not >5
REgards,
Alan.
"Alan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try using Conditional Formatting in C1 using 'Formula Is' with these three
> formulas in the three conditions, then highlight the whole of column C and
> go to Conditional Formatting again, OK
> =AND(COUNTIF(C:C,C1)>5,COUNTIF(C:C,C1)<11)
> =AND(COUNTIF(C:C,C1)>10,COUNTIF(C:C,C1)<16)
> =COUNTIF(C:C,C1)>15
> Regards,
> Alan.
>
> "ConfusedinCalgary" <(E-Mail Removed)> wrote in
> message news:CD8A859E-A4AD-45C2-A919-(E-Mail Removed)...
>>I still can't get it to work. I know it is obviously operator error but
>> still need some help. My data is in column C which grows longer every
>> day.
>> Every conditional format I try recognizes the first condition but not the
>> second and third. For example a number may appear 12 times but it still
>> codes with the color from 5-10. What am I doing wrong?
>>
>> "Alan" wrote:
>>
>>> 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,A1)<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" <(E-Mail Removed)> wrote
>>> in
>>> message news:7DA03CA1-B1B1-4B88-A671-(E-Mail Removed)...
>>> >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?
>>>
>>>
>>>
>
>
|
Similar Threads
