| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF based on cell shading
Is it possible to write a SUMIF formula based on cell shading? If so, how? I
want to add up cells based on the shading of the cell. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF based on cell shading
How did the cells get shaded?
If by Conditional Formatting then use the same criteria in your SUMIF If manually shaded you will need VBA See Chip Pearson's site for code. http://www.cpearson.com/excel/colors.aspx Gord Dibben MS Excel MVP On Wed, 17 Feb 2010 12:55:01 -0800, IlliniEric wrote: Is it possible to write a SUMIF formula based on cell shading? If so, how? I want to add up cells based on the shading of the cell. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Apply cell shading based on adjacent cells in EXCEL | Excel Worksheet Functions | |||
| Shading a range based on a single cell value. | Excel Discussion (Misc queries) | |||
| Excel formulas based upon the color shading of a cell? | Excel Worksheet Functions | |||
| how do you set auto shading of cell based on percent value in exc. | Excel Worksheet Functions | |||
Linear Mode
