home page
Questions? E-mail us or call us 302-584-1771, 8AM to 10PM U.S. East Coast Time 7 days a week

View Cart

US $24.95

Add to shopping cart


Money back

Conditional Format Assistant
An add-in product for Microsoft Excel

  • Format cells based on many different tests
  • Not memory intensive
  • Does not slow down Excel
  • Menu driven for ease of use
  • Easy to learn via help and exercises

Download a trial version now!

The Conditional Format Assistant add-in for Microsoft Excel is designed to help you format cells based on hundreds of different conditional tests.  It is compatible with Microsoft Excel 2007 to 2021 and Office 365.

The conditional tests are specified on a 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 dialog 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.

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 found in Excel.

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

Add to shopping cart

  US $24.95

Copyright 2023 LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of LLC.