Sum Cell value by font color

[Santhosh Mani]

Hi
Is it possible to sum the value in a range of cells based
on the color of font applied for numbers. If I have
numbers in Cell A1:A10 and the numbers in cell a3, a5, a6
are colored in red, I need the total of a3,a5 and a6.

Thanks in advance for your help
Santhosh Mani
Kuwait

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm

 

[Santhosh Mani]

Dear Mr.Frank
Thank you so much for your help. I applied Xldynamic
function. But it works with cell color not with Font
color. What I did is copied the colorindex function in
the workbook VB module and applied the formula =sumproduct
(--....). My requirement is fulfilled even with cell
color but to get sum on font color, should I do something
else.

Thank you again for your great help

Santhosh Mani
Kuwait

 

[Santhosh Mani]

Dear Mr. Frank
Please ignore previous reply, I did not check all the
formulas listed, was little bit confused, but now I found
how to get the sum on font color. Thank you again
Santhosh Mani