|
Conditional Formatting for Excel
Conditional Formatting for Excel can format all the Excel cells and ranges you may need, by using "n" conditional levels, and
analyze your Microsoft Excel spreadsheets' information easily and swiftly.
To facilitate analysis of any given information of your Excel spreadsheets, you could provide a special format (for example,
by highlighting in a certain color) using one of the most useful tools available with Microsoft Excel: "Conditional Formatting".
The only drawback: this tool only supports three conditional levels.
Jabsoft knows about this shortcoming, so it has created Conditional Formatting for Excel, an excellent complement to Excel,
which will allow you to format all the cells and ranges you may need, by using "n" conditional levels. This means that you
can use all the levels you want.
Just imagine working with Conditional Formatting for Excel along with other Jabsoft products, such as Stock Quotes for Excel.
You could rapidly – at a glance – get to know the latest market prices in your spreadsheets, by simply having Stock Quotes
configured to be updated every 30 minutes, and Conditional Formatting for Excel configured to add a given color to all cells
containing the latest prices.
Software Information |
System Requirements |
Version: |
2.1.0 |
- Windows XP/2003/2008/Vista/7
- Excel 2007 or more
- 128 MB RAM
|
License: | Free to try, $39.90 to buy |
File Size: |
4.88 MB |
Screenshot: | View Screenshot
|
Rating : | |
Key Features of Conditional Formatting for Excel:
- Formatting with "n" conditional formatting levels
Multiple conditional analysis & formatting is the tool suitable to format cells in a database.
- Cell's math by format
Use this gainful tool to search all cells in a specific range with a particular background color and to do some math with the results.
- Searching easily
This is a useful tool that has been designed to make searching in a data range both simple and efficient.
- ...By format
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.
- By logic criteria
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.
- By text
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.
- Cell's math with selected cells
You may want to do some math only with selected cells in the active worksheet
- Conditional Text
Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified
in the decision table.
- Conditional Text in activesheet
It is the tool suitable to format cells in a range/database based on a criterion previously specified in the decision table.
- Conditional Text in selection
Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified
in the decision table.
- Sumif & Countif
This useful tool allows you to sum and count data regarding to conditions specified in a criteria table.
- Sumif
In order to understand the SUMIF option functionality, Think about the following situation...
- Countif
In this case, we have a table with the names and the score of each one of them, also a criteria table.
- Saving models
You often happen to run the same models once and again, so the process of filling in the same information becomes repetitive.
- Specifying cells
This tool selects cells of a given range, but only taking into account those with a given format.
- Exporting sheets as...
Do you only wish to export any sheets of your workbook? Use the "Export sheets as..." tool, and simplify this task.
- Managing Sheets
Use Sheet Manager –a comprehensive tool that will make any worksheet management task easier to you.
- Managing Workbooks
Managing your open workbooks is made easy with the Workbook manager tool.
- Freeze | dividing panes
We sometimes work with models whose information does not fit in the screen.
- Toggle settings
We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets
of the Workbook, we will have to do it one at a time.
RELATED SOFTWARE DOWNLOADS FOR CONDITIONAL FORMATTING FOR EXCEL
|
|