adding specific font colors

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 a custom function. Chip Pearson provides some code that will do just that on his pages.

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

HTH

DominicB

Take a look at

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

In article <[email protected]>,
onyx4813 <[email protected]>
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?

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

--

HTH

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


"onyx4813" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>