Software Search Loading...

Map & Identify Excel Formulas

Color Code Formulas At 3 Levels

Pretty well all Excel spreadsheets contain formulas of some sort. They can range from a simple addition through to complex nested Functions. The formula types you can specify for Formatting (font and/or background) are;

Referencing other Workbooks
Referencing other sheets in Workbook
Referencing active sheet
Do not use cell references, eg =1+5, =200/50 etc
All types

Once applied, you can tell at a glance which cells contain formulas and which do not. You will also be able to tell at a glance the type of formulas (see list above) each cell has. This eliminates the need to go clicking through cells to find a specific formula type. So now you can;

Map your spreadsheet by formula type.
Format the background color of all formulas that match the criteria you set.
Format the font of all formulas that match the criteria you set.

30 Day Money Back Guarantee & Big Discount for Unlimited License. Only $44.95

You will be able to download your Excel Add-in immediately after ordering.

The Formula Manager is designed to make the managing of all formulas in Excel a breeze. It can be used in four main areas

Format (This page)

Report

The formula as in the cell.
The address of the cell.
The sheet is resides on.
Auto filter is also automatically applied for ease of reading and filtering.
Report includes Clickable Hyperlinks direct to the specified formula cell.

Protection

Lock and hide formulas
Lock only formulas
Hide only formulas
Lock/Hide and protect all Worksheets in one go.

Copy

Copy without formula references changing
Copy and transpose (row to column or column to row) without formula references changing

Excel Formula Manager Start

Formula Manager Excel 97 through to 2003 Compatible Payment Problems/Options SAVE by buying as part of a Add-ins collection

Order Type: