Excel Color Conventions for Financial Modeling: The Standard Nobody Wrote Down

Every bank uses the same color scheme in Excel, and almost nobody can tell you where it came from. There's no official spec. No committee published it. It spread the way most banking conventions spread: analysts copied the models of the analysts before them, and by the mid-2000s it had hardened into something close to law.

If you're new to a modeling seat, here's the standard, why it exists, and how to apply it fast enough that it stops being a chore.

The core convention

Blue text: hardcoded inputs. Any number a human typed. Assumptions, historical figures pulled from a filing, a growth rate someone chose. Blue means "this is where you change things" and, just as importantly, "this is where the model can be wrong because a person was involved."

Black text: formulas. Calculations that reference other cells on the same sheet. Black cells should never contain a typed number. The moment someone writes =D14*1.05+200 in a black cell, the model has a landmine in it, because that 200 is now invisible to everyone who assumes black means pure calculation.

Green text: links to other sheets. A cell on your DCF tab pulling from your assumptions tab is green. The point is traceability. When a reviewer sees green, they know the real logic lives somewhere else and they know to follow it.

Red text: links to other workbooks. External links are the most fragile thing in Excel. Files get renamed, moved to different folders, or emailed around until the link points at a path on someone's old laptop. Red is a warning color for a reason. Plenty of shops go further and simply ban external links in any model that leaves the building. I think they're right.

Some firms add wrinkles. Purple for links to data providers like CapIQ or FactSet plugins. Gray or yellow fill for cells that need attention before the model ships. Those vary. The blue-black-green-red core does not, and you can sit down at a model from almost any bank and read it.

Why anyone bothers

The convention isn't aesthetic. It's an audit protocol.

A senior person reviewing your model doesn't have time to click into a thousand cells. Color lets them audit visually. Scan a schedule: the blues should sit in the assumption rows and the historical columns, the blacks should fill the projection area, greens should appear only where the sheet genuinely depends on another tab. Any blue floating in the middle of a projection block is a hardcode where a formula should be, and it jumps off the screen.

That's the whole game. A correctly colored model can be skimmed for structural errors. An uncolored one has to be interrogated cell by cell, and nobody actually does that at 11pm before a board meeting, which is how mistakes get through.

It also protects you six months later. Every model becomes someone else's model eventually, including your own after enough time. Color is the documentation you didn't have to write.

Number formats are part of the standard too

Color gets the attention, but the number formatting conventions matter as much:

Negative numbers in parentheses, not minus signs. (1,250) reads instantly; -1250 gets lost next to a comma. The custom format most shops use is some variant of #,##0;(#,##0).

One decimal for percentages and multiples, zero for dollars in thousands. A revenue line showing $1,247.3 in a model denominated in thousands is telling you someone pasted from a source without reformatting.

Units stated once, in the header, not repeated in every cell. ($ in thousands) at the top of the schedule, clean numbers below.

Consistent decimals down a column. Mixed precision in a single row of comps is the formatting equivalent of a typo in the first line of a cover letter. Nobody will say anything, but everybody notices.

Applying it without losing your evenings

The naive way to follow the convention is to color cells as you build, one font-color menu click at a time. That's how it eats hours, and it's why half the models in circulation are only colored on the tabs a VP was likely to open.

Better options, in ascending order of effort saved:

Learn the F4 trick. Apply blue font to one input cell, then F4 repeats the last action on whatever you select next. Crude but fast for touch-ups.

Build cell styles. Excel's Cell Styles gallery (Home tab) lets you define an "Input" style and a "Link" style once, with font color, number format, and borders bundled together. Applying a style is one click and it standardizes formatting, not just color. Almost nobody uses this feature. The people who do finish formatting an hour earlier.

Keyboard-drive it. The real endgame is applying the full convention from the keyboard, and this is exactly the problem add-ins were built for. ExcelSurge's Quick Colors tool (full disclosure: our product) applies the entire standard in a keystroke: blue-input font, green links, finance number formats, borders and shading, one keypress instead of four menu clicks. Macabacus, the long-standing incumbent, does the same job. Either way, a whole schedule comes up to standard in about the time it takes to read this sentence. If you format models daily, a $20/month tool pays for itself inside the first week. If you format models monthly, cell styles are free and get you most of the way.

The part that actually matters

The convention only works if it's true. A model where blue mostly means input, where black formulas occasionally hide a typed constant, where some cross-sheet links are green and some aren't, is worse than an uncolored model, because it invites trust it hasn't earned.

So the discipline isn't "color your cells." It's "never let a color lie." When you hardcode something at 2am to force a check to tie, either color it blue right then or fix it before anyone sees the file. Blue that lies is how a placeholder becomes a valuation.

Check yours before it ships. Select the projection area and run a hardcode scan (we wrote up the native Excel methods in a separate post; in ExcelSurge it's the one-click Highlight Hardcodes tool). Every blue cell hiding in a formula block is a conversation you'd rather have with yourself than with your MD.