Count function - fill color

[Roberto]

Hi,
does it exist a COUNT function that matches a particular
criteria, i.e. COUNT THE NUMBER OF CELLS WITHIN A RANGE
FILLED WITH ORANGE COLOR?
bye+thx
Roberto

 

[Frank Kabel]

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

 

[Roberto]

I tried but it doesn't work. Do I have to add that code
into excel?
Thx
Roberto

 

[Frank Kabel]

Hi
yes you have to add this code in a standard module of your
file. This is otherwise not possible without using VBA