Conditional Formating Question

C

carl

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.
 
G

Gord Dibben

carl

The normal methods of determining the colorindex of a cell won't work with cells
colored by CF.

Can be done via VBA

See Chip Pearson's site for code.

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

Might be easier to do a COUNTIF or similar on the conditions that created the
colored cells.


Gord Dibben MS Excel MVP
 
C

carl

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 ?
 
Top