Sum Cell value by font color

  • Thread starter Thread starter Santhosh Mani
  • Start date Start date
S

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
 
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
 
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
 
Back
Top