PDA

View Full Version : count conditional format



lior03
05-15-2006, 06:28 AM
hello
is there a way to count cells according to there interior color if they are formated in conditional format?
thanks

johnske
05-15-2006, 07:19 AM
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
05-15-2006, 07:20 AM
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
05-15-2006, 03:34 PM
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.