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

Count coloured cells in range
 

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

Count coloured cells in range
 

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"
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