 |
|
|
|
|
|
|
|
|
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.
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)
- 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.
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
Formula Manager
Excel 97 or above |
Secure Payment Options |
30 Day Money Back Guarantee & Huge Discounts for Unlimited Licenses
| Buy on its own or
buy as part of the
Excel Add-ins Collection for not much more and get our
Complete Excel Course for FREE.
You will be able to download your Excel Add-in immediately
after ordering.
| Order Type: |
|
Single user license =2 users 2 computers| Unlimited user license = unlimited users unlimited computers | Resellers user license = Do anything you like with the add-in, including rebranding and reselling. That is, NO RESTRICTIONS AT ALL. Please email the support address and include your order number so we can send you the code password. Resellers user license ONLY
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS