Overdue deadlines

Premium

Highlight the row when the deadline has passed. Today's date is in G1. In D2, write the rule that tests whether the deadline in C2 is before G1. Lock column C and all of G1 with $.

D2
ABCDEFGH
1Task Owner Deadline Rule Today Nov 2, 2026
2Sales tax filing Sara Oct 27, 2026
3
4
5
6
7
8

Premium lesson

Unlock Conditional formatting and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:Drop-down lists and data validationCOUNTIF

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?