How to Color Code a Financial Model in Excel

Formatting & Productivity · Updated June 2026

Color coding is the first thing an experienced reviewer looks for in a financial model. It tells anyone opening the file which cells are hard-coded assumptions and which are calculated, so they know what is safe to change. The convention is simple, and once you adopt it your models become far easier to audit and hand off.

The standard color convention

Financial modeling has a widely accepted color standard that almost every analyst and bank follows.

Sticking to it means anyone can read your model without a legend.

Blue font for inputs and hard-coded constants, the numbers you type by hand.
Black font for formulas and calculations that live on the same sheet.
Green font for links that pull from another sheet in the same workbook.
Purple or red font for links to other workbooks, which are fragile and worth flagging.
Red font for errors or cells that need attention before the model ships.

Color cells by hand

You can apply the convention manually using the font color picker, but you have to decide the role of each cell yourself.

Select a cell or range you want to color.
On the Home tab, open the Font Color dropdown in the Font group.
Choose blue for a typed input, black for an on-sheet formula, or green for a cross-sheet link.
Repeat for every block of cells, checking each formula to confirm its role.
Apply a consistent set of colors across every sheet so the model reads the same way throughout.

Why doing it by hand breaks down

The manual approach works on a small schedule but falls apart on a real model with thousands of cells. You have to inspect every formula to decide whether it is a constant, an on-sheet calculation, or a link, and a single edit can quietly turn an input into a formula without the color following along. Most models end up partly colored and inconsistent, which is worse than no coloring at all.

Color an entire model in one click with ModelMint

ModelMint Color Coder reads each cell and applies the right color automatically: blue for constants, black for formulas, green for cross-sheet links, purple for external links, and red for errors. Run it on the selection, the active sheet, or the whole workbook, and the standard convention is applied everywhere at once. When you change a cell, just run it again to refresh the colors.

Do it in one click

Color Coder

Apply the standard modeling color convention automatically: blue constants, black formulas, green cross-sheet links, purple externals, and red errors, across a selection, sheet, or workbook.

Get ModelMint See how it works

FAQ

What color should inputs be in a financial model?

Inputs and hard-coded constants are colored blue. This is the most important part of the convention because it tells a reviewer exactly which cells are assumptions they can change versus formulas they should leave alone.

What does green font mean in a financial model?

Green font marks a formula that links to another sheet in the same workbook. It signals that the number is pulled from elsewhere, so if it looks wrong you should check the source sheet rather than the cell itself.

Is there an Excel feature that colors cells by type automatically?

Excel has no built-in tool for this, so analysts traditionally color cells by hand. ModelMint Color Coder applies the full convention automatically across a selection, sheet, or workbook.