How to create a visual map of hardcoded inputs vs formula cells in excel models
- Step 1Upload the financial model — Drop the .xlsx workbook to audit. ExcelJS loads every worksheet and classifies every cell.
- Step 2Run the highlighter — Formula cells receive a blue fill; hardcoded values receive amber. All sheets processed simultaneously.
- Step 3Open and review the highlighted model — In Excel, every assumption is immediately visible in amber — and every formula cell in blue. Audit at a glance.
Frequently asked questions
What are FAST modelling colour conventions?+
FAST Standard uses blue for formulas, black on yellow for hardcoded constants. The tool approximates this with blue and amber fills.
Does it highlight cells with conditional formatting formulas?+
Conditional formatting rules are stored separately from cell formulas. Only cells with direct formula values are highlighted in blue.
Can I use the highlighted version for peer review?+
Yes. The highlighted workbook is a standard .xlsx — share it with reviewers who can open it in any Excel version.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.