Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week
|
||
Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
||
|
|
|
|
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 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. 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.
|
|
|||||||||||||||||||||||||||||||
| Copyright 2009 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |
