The Conditional Formatting Functions add-in for Excel enhances the built conditional formatting functionality of Excel and offers solutions to utilize conditional formatting to apply math functions and tasks.
In order to simplify the analysis of specific data in a spreadsheet application it is common to apply conditional formatting within Excel. However, Excel's default conditional formatting functionality is limited to just 3 levels of conditions.
Conditional Formatting Functions for Excel can apply conditional formatting to format an cells and ranges with an unlimited number of conditions.
Conditional Formatting Functions for Excel is useful when working with large quantities of information or dynamic data such as stock quotes reports. As such spreadsheets periodically update automatically, the changes are highlighted with relevant colors in order to make quick and informed decisions.
Key features of Conditional Formatting Functions include:
Unlimited number of conditional formatting levels - The multiple conditional analysis and formatting tool is suitable to format cells based on a criteria previously specified in the decision table.
Apply Cell's math by format - Use this tool to search all cells in a specific range with a particular background color and apply some mathematical functions to the results.
Searching easily - A useful tool that has been designed to make searching in a data range both simple and efficient. Search by format, logic criteria, or by text.
Cell's math with selected cells - Apply mathematical functions to only the selected cells in a worksheet and choose output cells.
Saving models - Conditional formatting rules and functions can be saved and later applied to subsequent models and analysis.
Specifying cells - This tools enables the selection of cells based on format including number format, font, color, cell color etc.
Exporting and Managing Sheets and Workbooks - These tools facilitate the exporting of sheets to new books, copying and moving sheets and workbooks in an efficient manner.
Toggle settings - Save valuable time doing repetitive tasks. For example, to hide the headings in several sheets of the Workbook, instead of doing it one at a time,this powerful tool can automate it to save time.