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?