How do i formulate to add certain colored numbers?
 

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.

How do i formulate to add certain colored numbers?
 

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,


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=566430

How do i formulate to add certain colored numbers?
 

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

On Sun, 30 Jul 2006 09:41:02 -0700, Jawz22
wrote:

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.