Conditional Formatting vs Static Fill Which Slows Excel More

A static fill's price is paid in storage and territory, not in thinking time.

1. Each formatted cell adds a format record to the file — trivial for a header row, heavy when whole columns are painted (a million records per column)
2. The used range grows to cover the painted territory, so opens, saves and some operations drag
3. But at working time the fill is inert: scrolling past a yellow cell costs Excel nothing extra
4. Verdict: static fills make files fat, and fat files open and save slowly — they rarely cause mid-work lag by themselves

A rule's price is paid in repeated evaluation, and the bill arrives while you work.

1. Every scroll, redraw and recalculation re-evaluates each rule over its full range — a rule over a whole column is a million checks, repeated constantly
2. Rules with formulas cost per cell; rules built on volatile functions like INDIRECT or OFFSET re-trigger even more often
3. Copy-paste fragments rules over the years, so one intended rule becomes dozens of overlapping ones — each still evaluated
4. Verdict: conditional formatting makes Excel busy, and busy Excel lags and hangs during editing and scrolling — the classic 'hangs while I work' complaint

The comparison pays off as a diagnostic shortcut.

1. Slow to open and save, huge file, fine once loaded → storage cost → audit used range, whole-column fills, style count
2. Opens fine, lags on scroll and every edit → evaluation cost → audit the conditional formatting rule list and rule formulas
3. Freeze exactly on the formatting click → suspect neither first — test the default printer driver, the cause proven in the video
4. Both diseases together are common in old shared files; treat them in order — storage trim first (it is mechanical), rule cleanup second (it needs judgement)

Some conditional formatting guards data that stopped changing long ago — last year's status column does not need a live rule any more.

1. Identify ranges whose values are final (closed months, completed projects) — their colours no longer need to react to anything
2. Note the colours the rule currently produces, delete the rule for that range, and apply the same fills directly as static formatting
3. The sheet looks identical, the evaluation cost drops to zero for that range, and only the small storage cost remains
4. Keep rules where data is live — dashboards and trackers earn their evaluation cost honestly

The goal is not to abolish either tool — it is to stop paying the wrong price.

1. Static fills for fixed design: headers, banding inside a Table, totals — bounded ranges, applied once
2. Conditional formatting for live signals: values that change and must catch the eye — with the rule's range kept to the data, never the whole column
3. Never paint whole columns 'to be ready', and never leave a rule's range open-ended 'to be safe' — both habits are the same debt in different currencies
4. Review shared files yearly: trim the storage, consolidate the rules, keep both costs small