Sumbycolor of visible cells

A

avner

Hi,
How do i sum visible cells that are colored by a
conditional formatting color ?
10x
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match table shading (color) to Visio color/Transparency 1
Changing row background from external program 0
Fill tringle in a cell with color 1
Address Format changed after Migration 0
Tracked changes by multiple people modified to one 0
Student & Home? 1
sumbycolor formula 1
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0

Top