|
| Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
|
|
|
The Conditional Format Assistant is designed to help you format cells based on hundreds of different conditional tests. The conditional tests are specified on an Excel worksheet. The following illustrates such a worksheet:
The following are the tests (numeric and text) that you can use:
The Conditional Format Assistant main menu has a menu item titled Create a Conditional Format Assistant worksheet that constructs a worksheet like the one illustrated above. When you click in a cell in the conditions column, a drop down appears that gives you the above test choices. To format cells you would:
The Conditional Format Assistant comes with both a help file and an exercise file. The exercise file is the fastest and easiest way to learn to use the features of the Conditional Format Assistant. The formatting done by the Conditional Format Assistant is not dynamic. If the values of formatted cells change, you will need to re-run the Conditional Format Assistant. Nor does it increase the number of format conditional tests (3) found in Excel 97-2003.
|
|
| Copyright 2010 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. |
