Count coloured cells in range

[Alberto Pinto]

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

 

[Marcelo]

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

take a look at the Chip Person's page

hth
regards from Brazil
Marcelo

"Alberto Pinto" escreveu:

 

[Gord Dibben]

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

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