See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
example

--

HTH

Bob

"Atiq" wrote in message
...
Hello experts,

I have an excel workhseet where different cells are filled with different
colors. I need to count no of cells in a specific column with a specific
colour filled. For example i need to count how many cells are filled with
green color and how many with red etc. What formula i should use?

Thanks in advance,
Atiq