Count based on Color

[indycamaro]

Is there a way to a do countif like formula based on a cells color?

Example we use conditional formatting for cells over or under a value, Red / Yellow / Green. I'd like to have a formula that looks across a row to count the Reds, then in another cell a formula to count the Greens etc.

I am able to do the count with an if statement that recreates the same test conditons as the contional formating but it would be much simplier to count the colors.

 

[Domski]

Not using standard Excel functions. As you have stated the solution is to do a conditional count based on the same criteria as the formatting.

Dom

 

[Andrew Poulsom]

Actually, it's much simpler to count using the CF condition.

 

[MrKowz]

You cannot. If the cells were manually colored, you could use a VBA function to count them, but VBA cannot count conditionally colored cells (aside from using the conditions, themselves, in the code).

 

[VoG]

Unfortunately it isn't simple. See http://www.cpearson.com/excel/CFColors.htm