Summing fields based on color

[neilh92064]

iIs there a way in excel 2007 to sum fields in a spreadsheet based on their
highlighted color? I have a mult row spreadsheet where I need to total costs
based on the color of the field the value is in.

Thanks