New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Spreadsheet basics›Highlight dates before today

Google Sheets · Verified tutorial

Highlight dates before today in Google Sheets

Add conditional formatting to B2:B4 with the custom formula =B2<TODAY(). Choose any visible fill color.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Add conditional formatting to B2:B4 with the custom formula =B2<TODAY(). Choose any visible fill color.

Step-by-step

1

Select the targetAdd conditional formatting to B2:B4 with the custom formula =B2<TODAY().

2

Apply the changeChoose any visible fill color.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

B2:B4 has a custom rule that highlights dates before today.

Common mistake

Typing the formula as plain text or placing it in the wrong cell.

Troubleshooting

Re-select B2:B4 and repeat the final action. B2:B4 has a custom rule that highlights dates before today.

Example spreadsheet data

This is the clean fixture used for the verified run.

Task	Due date
Review	43831
Publish	44197
Launch	44562

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Add conditional formatting to B2:B4 with the custom formula =B2<TODAY().
Apply the change. Choose any visible fill color.
B2:B4 has a custom rule that highlights dates before today.