The simplest overspend flag is =IF(C2>B2,"Over","OK"), where B2 is the budget and C2 is what you have actually spent. Nest a second IF to add a Warning band at 90 percent of budget, then add conditional formatting so the words also show as red, amber and green.
What is the basic formula?
Put the budget in column B and the actual spend in column C, with the flag in column D. In D2:
=IF(C2>B2,"Over","OK")
IF asks a question, here whether actual is greater than budget. If yes it returns the first text; if not, the second. Text in a formula goes in double quotes. Notice that spending exactly equal to the budget is OK, because the test is strictly greater than. If you want the budget treated as a hard limit that you should not touch, use >= instead and rename the label.
How do I add a warning band at 90 percent?
Nest another IF in the second part:
=IF(C2>B2,"Over",IF(C2>=0.9*B2,"Warning","OK"))
The order matters. Excel stops at the first test that is true, so the Over test must come first; otherwise a row at 120 percent would be labelled Warning. To avoid typing 0.9 in many places, put 90% in a cell, say F1, and write:
=IF(C2>B2,"Over",IF(C2>=$F$1*B2,"Warning","OK"))
Now you can change the band in one place. In Excel 2019 or Microsoft 365, the same logic reads better as:
=IFS(C2>B2,"Over",C2>=$F$1*B2,"Warning",TRUE,"OK")
IFS tests each pair in turn; the final TRUE is a catch-all. Older versions of Excel do not have IFS, so use the nested form there.
What does it return for real rows?
| Category | Budget | Actual | Used | Flag |
|---|---|---|---|---|
| Groceries | ₹10,000 | ₹9,200 | 92% | Warning |
| Fuel | ₹3,000 | ₹3,150 | 105% | Over |
| Dining out | ₹4,000 | ₹2,100 | 53% | OK |
| Utilities | ₹5,000 | ₹5,000 | 100% | Warning |
These are made-up figures. Groceries: 9,200 divided by 10,000 is 92 percent, at or above the 90 percent line, so Warning. Fuel is 150 over, so Over. Dining out is far inside the band. Utilities hit the budget exactly, which is not over but is at the limit, so it shows Warning.
How do I colour the flag?
- Select the flag cells, or the whole table range, such as $A$2:$D$20.
- Go to Home, then Conditional Formatting, then New Rule, then Use a formula.
- Enter =$D2="Over" and choose a red fill. Press OK.
- Repeat with =$D2="Warning" for amber and =$D2="OK" for green.
The dollar sign before D locks the column while the row number moves, so each row is judged by its own flag. A count of problems is useful at the top of the sheet: =COUNTIF($D$2:$D$20,"Over") returns the number of categories currently over budget.
Does the flag work on actuals from SUMIFS?
Yes. Column C can be a SUMIFS pulling the month's spend from your log. The IF formula only needs a number to compare, whatever produced it. If the actual is wrong, the flag will be wrong too, so check one category by hand when you first set it up.
Should the warning band be a percentage or a rupee amount?
Either works. A percentage scales with the budget, so 90 percent of ₹10,000 gives a ₹1,000 cushion and 90 percent of ₹1,000 gives only ₹100. If you prefer a fixed cushion, say ₹500 for every category, change the test to C2>=B2-500. Percentages feel fairer across categories of different sizes, while a fixed rupee margin suits a handful of similar-sized lines. Try both for a month and keep the one that nudges you at a useful moment.
Pitfalls
- Budget or actual stored as text, usually left-aligned, makes comparisons unreliable. Convert to numbers first.
- A flag at the end of a month tells you what happened; a flag that checks the pace mid-month needs the pro-rata approach from the pace formulas.
- Too many bands cause alert fatigue. Two thresholds are plenty.
If you prefer alerts without formulas, SpendixAI has budgets on Pro; the spreadsheet route remains handy for seeing exactly how the rule works.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


