|
 |
        |
|
INDIVIDUAL PRODUCTS:
PRODUCT COLLECTIONS: |
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 Cell 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 just those cells. Couple this with the Sum function and you can sum by color! It also works with Excel's other functions like Average Min and Max. The Colored Cells Assistant is menu driven and creates the formulas you need:
Approach one of the Colored Cells Assistant allows you to specify colors by name. 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.
| |
|||||||||||||||||||||||||||||||
| Copyright 2008 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Macro Systems. Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation. |
