Is there a way to SUMIF based on Color

[excelbetter]

Is there a way to SUMIF (or get the sum in general) if the text color of a cell is a certain color?

Thanks.

 

[venkat1926]

it is possible in excel 2007. otherwise a macro may be necessary

 

[excelbetter]

Thanks. How do you do it in Excel 2007? Can it be done in Excel 2011?

it is possible in excel 2007. otherwise a macro may be necessary

 

[T. Valko]

Is there a way to SUMIF (or get the sum in general) if the text color of a cell is a certain color?

Thanks.

See this:

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

Make sure you pay close attention to the section titled: Color Change And Calculation

 

[excelbetter]

Excellent. Thanks.

See this:

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

Make sure you pay close attention to the section titled: Color Change And Calculation

 

[T. Valko]

Excellent. Thanks.

You're welcome!