Try Chip Pearson's site. This page has examples of how to count colors.
http://www.cpearson.com/excel/colors.htm

"Jack_Feeman" wrote:

I didn't see any mention of this in my search so maybe it can't be done. I
have a color coded spreadsheet and want to count the number of instances for
each color. Any help is appreciated. Thanks Jack