count conditional format

[lior03]

hello
is there a way to count cells according to there interior color if they are formated in conditional format?
thanks

[johnske]

The usual answer is no... However, there is a way, but it's by no means simple or easy - see here > http://www.xldynamic.com/source/xld.CFConditions.html

[austenr]

I don't think you can do that because CF does not use the same color index as regular cells. For instance, light green has a color index of 35 but I do not think CF uses that index.

[Zack Barresse]

CF does use the same index as regular cells, but it won't show that when looking at the worksheet object, only if you look/loop through all CF's.