Is there a formula to calculate numbers based on their font color?

For example, say cells B1 to B10 all have numbers in them. Half the
numbers have a font color of Red and the other half Green.

I would like to total all the red numbers with a formula.
Is there a way to do this?

Thank You


--
Costa
------------------------------------------------------------------------
Costa's Profile: http://www.excelforum.com/member.php...o&userid=26980
View this thread: http://www.excelforum.com/showthread...hreadid=401912