A avner Jun 29, 2004 #1 Hi, How do i sum visible cells that are colored by a conditional formatting color ? 10x
G Gord Dibben Jun 29, 2004 #3 Not too easily. You can't return the colorindex of CF colored cells. Could you count using the original condition that turned the cells colored? e.g. =COUNTIF(cellrange,">10")....or whatever the criterion is For more of CF colors and code see Chip Pearson's site. http://www.cpearson.com/excel/CFColors.htm Gord Dibben Excel MVP
Not too easily. You can't return the colorindex of CF colored cells. Could you count using the original condition that turned the cells colored? e.g. =COUNTIF(cellrange,">10")....or whatever the criterion is For more of CF colors and code see Chip Pearson's site. http://www.cpearson.com/excel/CFColors.htm Gord Dibben Excel MVP
