Count coloured cells in range

I would like to count how many coloured cells exists in a range:
for example 5 blue, 2 red, 3 yellow,...

Is there any function for this?

Thanks in advance

http://www.cpearson.com/excel/CFColors.htm

take a look at the Chip Person's page

hth
regards from Brazil
Marcelo

"Alberto Pinto" escreveu:

> I would like to count how many coloured cells exists in a range:
> for example 5 blue, 2 red, 3 yellow,...
>
> Is there any function for this?
>
> Thanks in advance
>
>
>

No built-in function.

User Defined Function can be employed.

See Bob Phillips' site for more on this.

http://www.xldynamic.com/source/xld.ColourCounter.html


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 19:01:47 +0100, "Alberto Pinto" <asapinto@hotmail.com>
wrote:

>I would like to count how many coloured cells exists in a range:
>for example 5 blue, 2 red, 3 yellow,...
>
>Is there any function for this?
>
>Thanks in advance
>

Gord Dibben MS Excel MVP