Count Cells based on background color of conditional formats

[scrabtree23]

I have a range of cells say A1:A10. Depending on the condition, the conditional formatting either colors the background yellow, green or red.

yellow (.ThemeColor = xlThemeColorAccent4 & .TintAndShade = 0.799981688894314)

green (.ThemeColor = xlThemeColorAccent6 & .TintAndShade = 0.599963377788629)

red = (.Color = 8420607 & .TintAndShade = 0.)



I need either a VBA or a formula to count each color. The number of yellows in B1, the number greens in B2 and the number of reds in B3.

[JLGWhiz]

Chip Pearson has a nice article on what it takes to use colors created by conditional format.
http://www.cpearson.com/Excel/CFColors.htm
It would be better if you can define the condtions that create the colors.