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" <(E-Mail Removed)> wrote in message
news:91C51963-8CC9-4578-9B0E-(E-Mail Removed)...
>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