Calculate based on the color of the cell Closed

Question

Hello, 



I am trying to write an if formula in Excel 2007 that will calculate the sum of all the cells that are a certain color.  Can you help me do this?  For instance if the cell is green then I want to add all the green cells, yellow? add the yellow cells, red?  add the red cells.  

Can this be done?

Thank you!

Pam

venkat1926 · Answer

you need a macro 
see this webpage

http://www.cpearson.com/excel/colors.aspx

see this section

Function SumColor(TestRange As Range, SumRange As Range, _
    ColorIndex As Long, Optional OfText As Boolean = False) As Variant

Calculate based on the color of the cell

1 response

Similar discussions

Subscribe To Our Newsletter!