count in a range by a specified color index

[cwistopho]

I have a range of cells with various values with two different color index's
(red and blue). Red indicates that the tool is down, blue that it is up. I
am searching for a way that I can write a formula to count by the color index
5 (Blue), but have found no functions for this and am not savvy enough in my
VBA skills to write this user defined function.

 

[Alan]

There is no built in function to do this in Excel. you need to use VB
coding, see here,
http://www.cpearson.com/excel/colors.htm
Regards,

 

[Bob Phillips]

Take a look at

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