If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|