No, that is impossible without seeing the workbook, and what you have done
to it, unless you can give a much more detailed explanation.

--

HTH

Bob

"Atiq" wrote in message
...
Thanks Bob.
I went through this link and followed instructions. Now forumal is giving
no
errors but result of formula is 0 though there are 20 cells in that
specified
range (A1:A100) filled with Red color.

Can you please advise whether i am making any mistake?

Thanks in advance, Atiq

"Bob Phillips" wrote:

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



.