Sum data based on Font Color

[Calicarrie]

Is it possible to sum up all values in a column that have the font color of "red"? This is a manual change in the font color -- it is not based on "accounting " format that would give negative values the red font. It seems that I have seen this somewhere, but I cannot find it.

Thanks for any help!

 

[jeffreybrown]

Try this...

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

 

[leezhihong]

You can use find(Ctrl+F) to sum the same color value.

 

[Krishnakumar]

Hi,

or Color Functions