adding specific font colors

[onyx4813]

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?

 

[JE McGimpsey]

Take a look at

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

 

[dominicb]

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

 

[Bob Phillips]

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

--

HTH

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