The forklift's annual OSHA inspection was three weeks overdue — nobody noticed until the auditor was standing on the floor. The date had been in the Excel sheet the whole time. Excel just never said anything.
That's how the expensive misses happen — fines, liability, downtime: not because the date is missing, but because nobody looked at the right moment. A date in a cell is only visible while the file is open and someone has that exact row in view.
This article shows the three Excel methods that genuinely make deadlines visible — step by step, with formulas you can copy — and the limit where even the best spreadsheet method fails (and what helps then).
=C2-TODAY() formula, and a status text, Excel makes deadlines visible. But: all of it only works while the file is open. Reminding you — by email, even when Excel is closed — is something Excel can't do. That's the difference between "visible" and "you won't miss it".Here's the goal — a deadline list that tells you at a glance what's on fire:
Method 1: Highlight due and overdue dates (conditional formatting)
Conditional formatting colors cells automatically based on a rule. Here's how to build the traffic-light view above:
- Select your date column, e.g.
C2:C200. - Home → Conditional Formatting → New Rule → "Use a formula to determine which cells to format".
- Add two rules (the top rule wins when both match, so put "overdue" first):
Rule 1 — overdue (red fill):
=AND($C2<>"",$C2<TODAY())
Rule 2 — due within the next 14 days (yellow fill):
=AND($C2>=TODAY(),$C2<=TODAY()+14)
The reference $C2 (column locked, row relative) makes the rule apply to each row individually. TODAY() recalculates every time you open the file, so the colors update themselves.
Tip: to color the entire row instead of just the date cell, select
A2:D200and keep the same locked reference$C2in the formula.
Method 2: Days until the deadline — and a status text
Colors are great for the eye, but sometimes you want a concrete number or word. Two helper columns:
Days until due (column D):
=C2-TODAY()
Format as a number. Positive = days remaining, negative = days overdue.
Status as plain text (great for filtering):
=IF(C2<TODAY(),"overdue",IF(C2<=TODAY()+14,"due soon","on track"))
Now you have a column that reads "overdue / due soon / on track" — something you can filter and sort even without colors.
Method 3: Sort & filter
With the days or status column, the rest is easy:
- Sort by "Days" ascending → the most urgent deadlines rise to the top.
- Filter (Home → Sort & Filter → Filter) on the status column → show only "overdue" when you're cleaning up.
That's enough for a clean, living deadline list — as long as someone opens the file regularly.
The three methods compared
| Approach | Makes it visible | Actively reminds | Works when Excel is closed |
|---|---|---|---|
| Conditional formatting | ✓ colors | — | No |
| Days/status formula | ✓ number & text | — | No |
| VBA macro with pop-up | ✓ alert | ✓ only while Excel is open | No |
You can see the pattern: Excel is great at making a deadline visible — but none of it reminds you when nobody has the file open.
The limit every spreadsheet hits
All three methods share one weakness: they only work on a screen someone currently has open. Conditional formatting turns a cell red — in a file that's been closed on a drive for three weeks. Even VBA macros only run while Excel is open.
That's exactly where the expensive misses happen: the deadline passes, and nobody noticed — because nobody looked at the right time.
"Can't I just set an Outlook reminder?"
The obvious reflex — and for one fixed date it works. With deadlines that live in Excel, it breaks down in three places:
- You maintain every date twice (in Excel and in the calendar) and have to keep them in sync.
- Recurring inspections, whose date moves forward after each completion, don't update along.
- The reminder sits in one person's calendar. If they're out sick or on vacation, nobody sees it.
CellAlert reads straight from your Excel sheet — the source — and reminds the whole team.
What CellAlert does differently
You mark a deadline cell once in the Excel add-in; a click on "Refresh" later pulls in any changed dates from Excel. CellAlert monitors the deadline server-side and reminds you in time — by email and in your calendar — even when Excel is long closed, the computer is off, or the file is lost.
And if you're (rightly) wary of cloud tools: CellAlert doesn't store your Excel file — only the deadline itself plus a cell reference (file/sheet/cell). Your data stays yours: CSV export anytime, no lock-in. Your spreadsheet stays the source of truth — CellAlert just adds the reliable reminder layer on top.
Frequently asked questions
Can Excel email me automatically about a deadline?
Not on its own. Excel has no built-in feature that sends an email without the file being open. VBA macro workarounds exist, but they only run while Excel is open — and have to be set up and maintained per file. A reliable reminder when the file is closed needs a service that monitors the deadline outside of Excel.
Does conditional formatting with TODAY() update on its own?
TODAY() always returns the current date and recalculates every time the file opens. So the coloring is always "live" — a cell that was green yesterday can be yellow today. For a fixed cut-off view, enter the date as a static value instead.
Do I lose my spreadsheet if I use CellAlert?
No. CellAlert doesn't replace Excel and requires no migration. It stores only the deadline metadata plus a cell reference — not the file itself. Excel stays the source of truth, and exporting your deadlines is always open.
What about deadlines that live with a single person?
That's the bigger risk behind the spreadsheet: if the file sits on one machine and reminders go to one personal inbox, nobody is in the loop when that person is out sick or on vacation. CellAlert makes deadlines visible to the whole team, so a single absence never means a missed deadline.
Excel makes your deadlines visible — CellAlert makes sure you never see one for the first time when it's already too late.