I am a column that has the numbers in color, is it possible to add the
numbers together by color, i.e. all red,all blue? If so what would the
formula be.

Thanks

There is no way to do this with a worksheet function. You need a
VBA function. See http://www.cpearson.com/excel/colors.htm .


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


"D" wrote in message
...
I am a column that has the numbers in color, is it possible to
add the
numbers together by color, i.e. all red,all blue? If so what
would the
formula be.

Thanks