How do i formulate to add certain colored numbers?

[Guest]

I am trying to formulate a spreadsheet where the sum in one cell will
automatically add blue numbers when put into the row. If anyone know how to
do this please let me know. Thank You.

 

[mrice]

If you look at my homepage, you will find a macro which sorts by colour.
A simple adaptation should allow you to add by colour,

 

[Gord Dibben]

If you mean Sum up the cells with blue color or text you will need VBA to
achieve this.

See Chip Pearson's Sumbycolor

http://www.cpearson.com/excel/colors.htm


Gord Dibben MS Excel MVP