How to colour-code excel model input assumptions for training and model handover
- Step 1Prepare the model for handover or training — Complete all formula work. Save the .xlsx before running the highlighter.
- Step 2Apply the amber/blue colour coding — Upload and run. ExcelJS applies amber to hardcoded input cells and blue to formula cells across all sheets.
- Step 3Deliver the highlighted model — Trainees or inheritors see immediately which cells are inputs and which are calculated — reducing errors and support questions.
Frequently asked questions
Is this highlighting compatible with Excel's own formula auditing tools?+
Yes. The cell fill colours are standard formatting and coexist with Excel's Trace Precedents and Dependents arrows.
Should I remove the highlighting from the final production model?+
For client-facing deliverables or regulatory submissions, remove the fills. For internal training copies, keep them.
Can users in the training session change the amber input cells?+
Yes. The amber highlighting is visual guidance only — it doesn't protect the cells. Add Excel's Protect Sheet if you want to lock the blue formula cells from editing.
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.