Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of all cells with red shading
I want to add all cells that have a certain color of shading. For example, in
one cell, give me the sum of all cells with red shading. In another cell, give me the sum of all cells with blue shading. This is so straightforward that Excel must be capable of doing it, but how to tell it what I want? This is related to the concept of conditional formatting, but kind of the reverse of it. I am a regular Joe who is not fluent in VBA or macros. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shading Cells | Excel Discussion (Misc queries) | |||
shading used cells only | Excel Discussion (Misc queries) | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
Shading Cells | Excel Discussion (Misc queries) | |||
Shading Cells | Excel Worksheet Functions |