Excel formula - select cells based upon fill color and then sum

-----Original Message-----
I want to sum data baed upon the fill color. An existing
spreadsheet
has been manually shaded to show the "selected cells". I
want to write
a formula to look for a specific shading, find the
specific color, and
then add the cells that are shaded the correct color. Is
this
possible? I know there are formulas to select cells
based upon text
color but I can't seem to find a formula that selects
cells based upon
background color.


---
Message posted from http://www.ExcelForum.com/

.
im not sure if there is a formula you can use for that,
but you can incorporate it using a conditional
formatting. select format, then conditional formatting,
and select which ones you want highlighted. then use the
sumif function, with the now highlighted cells you just
formatted. this is the only way i know of.