Upload a workbook and the tool turns hardcoded input cells blue so they stand out from your formulas, the classic modeling convention. Runs in your browser, your file is never uploaded.
Inside Excel, ModelMint's Color Coder distinguishes inputs, formulas, and links by role across a model in one click, with conventions you control. $89 a year.
In financial modeling, the long-standing convention is to make hardcoded inputs blue and leave formulas black, so a reviewer can instantly tell which cells are assumptions and which are calculated. This tool applies the first half of that convention automatically: it finds the literal constant cells in your workbook and recolors their font blue, while preserving number formats, borders, and fills. Your formulas and values are never changed, and your original file is untouched, you download a separate copy.
This is a quick, browser-based version and is in beta, so run it on a copy. The full ModelMint Color Coder handles inputs, formulas, and cross-sheet links by role with conventions you set, live in Excel.
How do I color-code a financial model in Excel?
Upload the workbook and the tool turns constant cells blue. See our guide on color-coding conventions.
Why are inputs blue in financial models?
Blue for inputs and black for formulas lets a reviewer see at a glance which cells are assumptions to change and which are calculated.
Will this change my numbers or formatting?
It only changes the font color of constant cells and preserves number formats, borders, and fills. It is in beta, so test on a copy.