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

  • Thread starter Thread starter mfrye
  • Start date Start date
M

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

.
im not sure if there is a formula you can use for that,
Click to expand...
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.
 
Back
Top