You need to use a VBA function. See
www.cpearson.com/excel/colors.htm for details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"JRJ" wrote in message
...
I want to count cells based on the color that they have been
formatted.
e.g. Count the number of yellow cells, count the number of
green cells.

Is this even possible?

Thanks.