Colored Cells Assistant

A specialty add-in product for Microsoft Excel

Do you have this problem:

• Need to sum cells based on color identification?

The Colored Cells Assistant can solve this problem and more!
 

The Colored Cells Assistant for Microsoft Excel adds a feature that is missing in Excel: The ability to use Excel functions and base the results on cell color. The Colored Cells Assistant will return just the cells with the color you indicate.  For example, if you color some cells in a range with a yellow background you can use a Colored Cells Assistant function to return or sum just those cells. It can easily average, find the minimum or maximum, or the count colored cells. And you can use it with any of Excel's functions.

The Colored Cells Assistant is menu driven and creates the formulas you need:

 
                       Approach 1    

Approach one of the Colored Cells Assistant allows you to specify colors by name. 

                   Approach 2

Approach two lets you specify the colors by a reference cell.  With the second approach you can change the reference cell's colors to get results on a different set of cells.

You can also set the background color option to be "colored" so that you can sum, average, count, etc cells that are yellow, blue, green, or any color except no fill.  This allows you to color cells any way you want and still do computations on just the colored cells.

The Colored Cells Assistant only recognizes cells colored using Excel's color buttons or by selecting a color via Format, Cells.  It does not recognize the color of cells formatted by conditional formatting.

If you send a workbook to another person and they do not have the Colored Cells Assistant, they will need to purchase a license to it in order for the Colored Cells Assistant functions to work for them.