Adding cells with different colors

[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)

 

[Chip Pearson]

You need to use a VBA function to sum by colors. See
www.cpearson.com/excel/colors.htm for details and example code.


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

 

[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?

 

[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

 

[Maurice]

Tools > Options > Calculate then set automatic

well in office 2002 it is