The real problem with the color coding system isn't the logic. It's that most people stop at the first layer. You follow the training, you map your greens to links, your blues to hard codes, your blacks to calculations, and then you step back and see a sea of green staring back at you. That's not a model. That's a monochrome mess. And when you're about to present a summary income statement to executives, the last thing you want is for every single cell to scream "linked to another sheet" as if that information matters to the person signing off on the valuation.
Here's what the system is actually for: it's a diagnostic tool, not a presentation format. The color coding is meant to help you audit the model, to spot errors, to trace dependencies. It was never designed to make your output look clean. When you're building a summary page that pulls from detail tabs, the links are the point. Of course they're green. But that doesn't mean the presentation layer should look like a traffic light. The fix is to separate the model's internal logic from the way you communicate it outward. That means creating a dedicated presentation view, one where the colors carry meaning for the audience, not for the spreadsheet.
In practice, that means rethinking what the colors signify on the summary page. If everything is green because it's linked, then green has stopped communicating anything useful. Instead, use color to highlight what's worth the executive's attention: a variance that needs explanation, a hard-coded assumption that drives the valuation, a cell that behaves differently from its neighbors. The detail sheets can stay coded for your own audit trail. The summary sheet should be coded for clarity. That might mean stripping the colors back entirely and using formatting only where it directs attention, not where it merely reflects structure.
The habit of over-coding is a symptom of treating the model as the deliverable. It isn't. The decision is the deliverable. The model is just the path. So when you present that summary income statement, ask yourself what the executive needs to see, not what the spreadsheet needs to track. If that means a clean, nearly colorless page with a few strategic highlights, that's not a failure of rigor. That's the difference between building a model that works and building a model that communicates. Start there, and the color logic stops being a source of eye strain and starts being a tool for persuasion.