Latest / ModeLoop: Financial Modelling in Excel

P2E12: Conditional Formatting in Excel for Financial Models - Flag Breaches & Errors
Conditional formatting in Excel for financial models turns a grid of numbers into a model that points at its own problems: covenant breaches, broken balance checks and formula errors surface themselves instead of waiting to be found.
In this episode:
Formula-based rules and why the $ signs decide which cells get checked
Five rules every model needs: covenant breaches, check rows, errors, timeline shading, negative cash
Data bars and colour scales for sensitivity tables, used with restraint
Managing duplicated rules in inherited models
📖 Full blog post…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.