why dont you count/test for the same condition that you use for the
formatting itself.....
--
paul
remove nospam for email addy!



"Francisco" wrote:

I have a list of data in column, they have conditioanal format to different
colors, e.g. blue, red, brown. I want to count the total number of blue.
How to do it ? The "CountIf" function does seem to help. Any suggestions ?
Thanks.