Adding cells with different colors

A

anb001

If you have a row with different numbers in the cells, and then giv
them different colors, is it possible to make some kind of formula
where you can add all cells which is yellow, red or blue, by the
selves (i.e. A1 and A4 are yellow, so they will added - A2 and A7 ar
red, so they will be added etc)
 
A

anb001

Thanks. Worked out fine. I have an additional questions, though.

To calculate the formula entered, I have to press 'F9' (Calculate Now).
Is there any way, this could be done automatically?
 
C

Chip Pearson

Unfortunately, changing a cells color does not cause Excel to recalculate,
so the function won't be called to recalc. You have to use F9 to force a
recalc.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top