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

[mfrye]

I want to sum data baed upon the fill color. An existing spreadshee
has been manually shaded to show the "selected cells". I want to writ
a formula to look for a specific shading, find the specific color, an
then add the cells that are shaded the correct color. Is thi
possible? I know there are formulas to select cells based upon tex
color but I can't seem to find a formula that selects cells based upo
background color

 

[Peo Sjoblom]

There are no built in functions but there are other ways

http://www.cpearson.com/excel/colors.htm

 

[Frank Kabel]

Hi
see
http://www.cpearson.com/excel/colors.htm

 

[Guest]

-----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.


---


.
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.