View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thomas M.[_3_] Thomas M.[_3_] is offline
external usenet poster
 
Posts: 2
Default Sum Column Based on Cell Color

Excel 2007

Is there a way to sum a column of numbers based on the background color of
the cells? For example, I have a column that contains gold, blue, and green
cells, and I want to sum only the green cells. The color definition is:

Red 153
Green 204
Blue 0


--
Thanks for any help that you can offer!

--Tom