This link will demonstrate the VBA solution:
www.cpearson.com/excel/colors.htm

No it wont this is for counting colorindex etc, counting CF colours is much
more difficult but have a look here

http://xldynamic.com/source/xld.ColourCounter.html


Mike

"Ron@Buy" wrote:

This link will demonstrate the VBA solution:
www.cpearson.com/excel/colors.htm


"Luke M" wrote:

The only way to count color is with VBA.

Using just formulas:
Why not count the cells based on what your formatted them by? (i.e., since
there's some formula governing what color the cell is, use that formula to
help determine the count!)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dave" wrote:

I have a column that has conditional formating applied and want to count the
number of cells that are red or green or any color.