How to colour-code formula cells and hardcoded values in excel
- Step 1Drop your Excel workbook — Upload the .xlsx model to audit. ExcelJS loads every worksheet.
- Step 2Run the highlighter — Formula cells get a blue (FFBDD7EE) fill; hardcoded cells get amber (FFEB9C). All sheets in one pass.
- Step 3Download the highlighted workbook — Open in Excel — every formula cell is visually distinct from hardcoded inputs. Audit instantly.
Frequently asked questions
Will the highlighting survive if I save the file in Excel?+
Yes. Cell fill colours are stored as standard XLSX formatting and survive any subsequent save or edit.
Can I customise the highlight colours?+
Custom ARGB colour inputs are on the roadmap. Currently blue and amber are the fixed palette.
Does it highlight cells with no value?+
Empty cells are skipped. Only cells with a formula or a non-empty hardcoded value are coloured.
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.