I think I'd try to mimic the conditional formatting formula in the formula that
would count the cells. I've found that working with conditional formatting
inside a userdefined function much more difficult than just mimicking those
rules.

For instance, if the orange colored cells are the ones that have "Apples" in the
cell, then:
=countif(a1:c9,"apples")
could be enough. (Yeah, a totally simple example!)



Kelly Lim wrote:

I would like 2 apologize to everyone who have help me on the post of
"Counting Cells" but im confused with everyone agreeing and disagreeing on
using this and that methods...which i don know where to make ammendments in
my code and formulas now....Thanks to u all first....

Could someone pls help me clearly on how should i do it?
My database contains some coloured cells.....with conditional
formatting.....and i would like to have maybe the calculation below
......which will calculate how many E.g. columns in red
columns in orange
columns in yellow
and etc........

Its urgent and i would be so glad if anyone can help me step by step
and clearly on this? Im not really good in Excel....that's y im trying to
learn..... Thanks to all.....

--

Dave Peterson