How do I add values fr/ cells with a given fill color (rose)?

[john]

How do I add values fr/ cells with a given fill color? I'd like to search a
column for a particular format and add all the values of the cells with that
format.

 

[willwonka]

I always start with cpearson's site for these kind of things..

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

Hope this helps.