Carl,
My mistake: refer to the site that Gord pointed to in his reply:

http://www.cpearson.com/excel/CFColors.htm

Use the CountOfCF function:


=CountOfCF(A1:A20,3)

will give count of RED cells in range A1:A20



"carl" wrote:

Thank You. I am not sure can do what I need. Basically I need to count the
number of cells in a range that are CF'ed Blue, Green. How can I use this
code to help me do that ?

"Toppers" wrote:

See:

http://www.cpearson.com/excel/colors.htm


"carl" wrote:


I have some cells that are conditionally formated to fill Blue, Green, or Red.

Is it possible for a macro or a formula to tell me the count of cells that
are Blue, Green, and Red over a given range of cells ?

Thank you in advance.