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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|