count in a range by a specified color index

C

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