Excel template · Instant download

Never miss a deadline again.

Colour-coded tasks that warn you before things go wrong. See what’s overdue, what’s due today and what’s next, and light up the row you’re working on with one key. No macros.

Get the tracker $12.99

✓ One-off payment   ✓ Instant download   ✓ Excel for Windows & Mac

Lee from Sheet Leveller
Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.
Task-and-Deadline-Tracker.xlsx
2 overdue1 due today3 due soon3 done
TaskPriorityDue DateStatusDeadline
Send Q3 report to managerHigh27 Sep 2026In ProgressOverdue
Renew car insuranceHigh28 Sep 2026Not StartedOverdue
Book dentist appointmentMedium29 Sep 2026Not StartedDue today
Prepare team meeting slidesHigh30 Sep 2026In ProgressDue soon
Pay credit card billHigh01 Oct 2026Not StartedDue soon
Order new printer inkLow02 Oct 2026WaitingDue soon
Fix leaking kitchen tapMedium05 Oct 2026WaitingOn track
Submit expensesMedium25 Sep 2026DoneDone
Start HereDashboardTasksSettings
Sound familiar?

A plain to-do list doesn’t warn you

⏰

Deadlines sneak up

A list of tasks doesn’t tell you what’s late. By the time you notice, it’s already overdue.

🎨

Everything looks the same

In a plain list, a finished task looks exactly like an urgent one. Your eyes have nothing to go on.

👀

Losing your place

In a long list it’s easy to read across the wrong row. It’s why my “Highlight the Active Row” video has been watched nearly 300,000 times.

How it works

Type a task. The colours do the rest.

  1. Add your tasks

    Task, category, priority and due date. Everything else is worked out for you.

  2. Update the status

    Pick Not Started, In Progress, Waiting, Done or Cancelled from the drop-down. The row changes colour instantly.

  3. Check the dashboard

    See what’s overdue, what’s due this week, your next 10 deadlines and how far through you are.

Automatic deadline warnings

Know what’s late before anyone asks

Every task gets a deadline flag that updates itself each day: Overdue in red, Due today in orange, Due soon in yellow, or On track. Overdue rows are tinted red so they’re impossible to miss.

  • Days left or days late for every task
  • Choose how many days counts as “due soon”
  • Done tasks fade out and get crossed off
Deadline column
Due DateStatusDays LeftDeadline
27 Sep 2026In Progress2 lateOverdue
29 Sep 2026Not StartedTodayDue today
01 Oct 2026Not Started2 leftDue soon
05 Oct 2026Waiting6 leftOn track
25 Sep 2026DoneDone
Highlight the active row

Light up your row. No macros.

Click any task and press F9: the whole row lights up so you never read across the wrong line. Most highlight tricks need macros, which bring up security warnings. This one uses a built-in Excel formula, so it just works.

  • Updates whenever you press F9 or type
  • No macros, no security warnings
  • Switch it off in Settings if you prefer
Tasks
F9Click any task, press F9, and the whole row lights up.
TaskPriorityDue DateStatusDeadline
Book dentist appointmentMedium29 Sep 2026Not StartedDue today
Prepare team meeting slidesHigh30 Sep 2026In ProgressDue soon
Pay credit card billHigh01 Oct 2026Not StartedDue soon
Order new printer inkLow02 Oct 2026WaitingDue soon
Live dashboard

Your week at a glance

The dashboard adds everything up for you: total tasks, done, overdue, due this week and overall progress. Your next 10 deadlines are listed with the overdue ones first, plus charts by status and category.

  • Updates automatically as you work
  • Open tasks by priority and category
  • Nothing to set up, no formulas to write
Dashboard
TOTAL15
DONE3
OVERDUE2
THIS WEEK5
Overall progress: 21%
Next deadlinesDueDeadline
Send Q3 report to manager27 Sep 2026Overdue
Renew car insurance28 Sep 2026Overdue
Book dentist appointment29 Sep 2026Due today
Prepare slides for team meeting30 Sep 2026Due soon
Who it’s for

For anyone juggling more than one thing

Office workers & teams

Reports, meetings and follow-ups in one place, with an Owner column so everyone knows who’s doing what.

Freelancers & small businesses

Client work, invoices and deadlines colour-coded, so nothing slips and no client gets forgotten.

Students & home life

Assignments, bills, appointments and renewals, each with a clear warning before it’s due.

Everything you get

  • Room for 500 tasks with filters and sorting
  • 5 colour-coded statuses and 3 priorities
  • Automatic Overdue, Due today and Due soon warnings
  • Highlight the row you’re on with F9, no macros
  • Progress bars, owners and 10 categories you can rename
  • Dashboard: key numbers, progress, next 10 deadlines and 2 charts
  • Example tasks that always show every colour
  • Start Here guide
Task & Deadline Tracker
$12.99

One-off payment. Yours to keep.

Get instant access $12.99

Secure checkout by Payhip · Card or PayPal
Download link emailed straight away

Lee from Sheet Leveller

Hi, I’m Lee

I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials. My videos on highlighting the active row and colour-coded drop-down lists have been watched nearly 400,000 times between them.

This tracker puts both of those ideas, and a lot more, into one ready-made spreadsheet, so you can start using it in minutes instead of building it yourself.

6.3Mtutorial views
11,900+YouTube subscribers
500tutorials

Questions

Does it use macros?

No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.

How does the row highlight work?

Click any cell on the Tasks sheet and press F9 (on a Mac, fn + F9). The row you’re on lights up. It also updates whenever you type something. You can turn it off in Settings.

Which versions of Excel does it work with?

Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.

Can I change the categories?

Yes. Rename them or add your own (up to 10) on the Settings sheet, and they appear in the drop-down straight away.

Can I use it with a team?

Yes. There’s an Owner column for who’s responsible, and you can filter by it. Save it somewhere shared, like OneDrive, and everyone sees the same list.

Is this a subscription?

No. You pay once and the file is yours to keep.

See what’s late. Know what’s next.

Colour-coded tasks, automatic deadline warnings and a live dashboard, in one simple spreadsheet.

Get the tracker $12.99

Not ready yet? Try the free Colour-Coded Task List.

Task & Deadline TrackerInstant Excel download
Buy · $12.99
Scroll to Top