To sum according to cells color

A

an

I have cells with Conditional Formatting, where there are
green or red cells, according to numeric value.

Is it possible to sum and/or to count values, according to
cells color?

Thanks in advance.
an
 
P

Paul B

an, see if this will help

http://www.cpearson.com/excel/CFColors.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
A

an

Thanks for your help.
an
-----Original Message-----
an, see if this will help

http://www.cpearson.com/excel/CFColors.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **




.
Click to expand...
 

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

Counting by color 3
Sum Column Based on Cell Color 5
countif function 4
Counting cell colours 4
Conditional Sum Based on Cell Background Color 6
Sum function when the values in an xls are color coded 2
Count the number of colored cells in a column 5
How to Color a Cell Based on a Range of Cells with Colors 1

Top