What formula do I use to add all numbers in different cells that are
blue in color or red in color or green in color?


--
onyx4813
------------------------------------------------------------------------
onyx4813's Profile: http://www.excelforum.com/member.php...o&userid=26305
View this thread: http://www.excelforum.com/showthread...hreadid=395801

Take a look at

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

In article <(E-Mail Removed)>,
onyx4813 <(E-Mail Removed)>
wrote:

> What formula do I use to add all numbers in different cells that are
> blue in color or red in color or green in color?

Good afternoon onyx4813

Unfortunately no such function exists, but it can be done by writeing
custom function. Chip Pearson provides some code that will do just tha
on his pages.

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

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=39580

An alternative http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"onyx4813" <(E-Mail Removed)> wrote in
message news(E-Mail Removed)...
>
> What formula do I use to add all numbers in different cells that are
> blue in color or red in color or green in color?
>
>
> --
> onyx4813
> ------------------------------------------------------------------------
> onyx4813's Profile:
http://www.excelforum.com/member.php...o&userid=26305
> View this thread: http://www.excelforum.com/showthread...hreadid=395801
>