COST TRACKING
Budget Alerts with Conditional Formatting
8 min read · Template referenced below
A budget spreadsheet only helps if you actually notice when something goes over. Conditional formatting turns passive numbers into an at-a-glance warning system.
1
Set up budget vs. actual columns.
Column B: Budgeted Amount. Column C: Actual Spent. Column D: =C2/B2 for percent of budget used.
2
Format column D as a percentage.
Select the column, then Home → Number Format → Percentage, so 1.15 displays as 115% instead of a raw decimal.
3
Add a red alert rule for over-budget items.
Select column D, then Conditional Formatting → New Rule → "Format only cells that contain" → Cell Value → greater than → 1. Set a red fill — anything over 100% of budget lights up immediately.
4
Add a yellow warning rule for items approaching budget.
Add a second rule: "between" 0.85 and 1, yellow fill — flags items closing in on their limit before they actually go over.
5
Optional: add data bars for a visual scan.
Conditional Formatting → Data Bars applies a proportional bar inside each cell — useful for scanning which categories are furthest along at a glance.
Order your conditional formatting rules carefully — Excel applies them top to bottom and stops at the first match unless "Stop If True" is unchecked, so a red rule listed above a yellow rule can silently override it.
Once this is set up, a weekly glance at the sheet tells you exactly which cost categories need attention — no need to manually calculate percentages every time.
Back to all tutorials →