• Home
• Products
  Product List New Products Downloadable Books Analysis Products Charting Products Data Products Specialty Products Time Saving Products Free Products How to Open and Use
• Download
  Download Information Download Purchased Software Download Upgrades
• Support
  Support Top Support Questions Ordering FAQ's Money Back Guarantee Product FAQ's Online Meeting Excel Problems & Solutions How to repair Microsoft Excel
• Contact Us
  How to contact us Contact Form
• About
  About Add-ins.com LLC Customer Feedback Policies License Agreement

Conditional Format Assistant A specialty add-in product for Microsoft Excel Order online from our secure service Get delivery in minutes! For Excel 97, 2000, 2002, XP, 2003, and 2007 Order Risk Free - Money back guarantee if not satisfied    $24.95 Buy individually or as part of the Productivity Suite and save!

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:

• between
• not between
• equal to
• not equal to
• greater than
• less than
• greater than or equal to
• less than or equal to
• Is
• Contains
• Begins with
• Ends with

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:

• Select the range of cells to be formatted
• Select the conditional format test rows from the above worksheet
• Click OK!

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.

Order online from our secure service. Get delivery in minutes!

$24.95