Excel Conditional Formatting for Dates After Today

How-to basics · Updated November 19, 2026

To highlight dates after today in Excel for Microsoft 365 on Windows, select the date cells, choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format, and enter =AND(ISNUMBER(A2),A2>TODAY()). This example assumes dates are in A2:A100; set the rule’s range to A2:A100, then choose a format. The rule highlights future dates, excludes today, and ignores blank cells.

What “after today” means in Excel

Excel stores ordinary dates as serial numbers, so a comparison can identify dates later than the current date. TODAY() returns today’s date, and the greater-than operator tests whether a cell’s value is later. Because the comparison is strictly greater than, a cell containing today’s date does not qualify; tomorrow and later dates do.

That distinction matters when a sheet tracks deadlines, bookings, renewals, delivery dates, or scheduled tasks. A rule for dates after today is not the same as a rule for dates that are today or later. To include today, the comparison must use greater-than-or-equal instead. Decide which meaning fits the report before applying a format.

Excel dates may also include a time component. A date-time value for today at 3 p.m. is numerically greater than TODAY(), which represents today at midnight. The basic rule can therefore highlight a timestamp from later today even though its calendar date is not in the future. A separate section below covers how to avoid that result.

Create the conditional formatting rule

  1. Select the cells containing dates, such as A2:A100. Start with the first data cell, not a heading, so the formula’s reference matches the top-left cell of the selected range.
  2. On the Home tab, choose Conditional Formatting > New Rule.
  3. Select Use a formula to determine which cells to format.
  4. For a range beginning at A2, enter =AND(ISNUMBER(A2),A2>TODAY()). The formula assumes the dates are in A2:A100, with A2 as the top-left cell of the Applies to range.
  5. Choose Format, set a fill color, font, or other available appearance, and select OK. Confirm the rule in the Conditional Formatting Rules Manager if you need to check or edit its range.

The ISNUMBER check is useful because a blank cell should not be treated as a date. Excel evaluates actual dates as numbers, so the check restricts highlighting to numeric date values. It also helps avoid treating text that merely looks like a date as a valid date. If the cells are guaranteed to contain only real dates or blanks, the shorter formula =A2>TODAY() works too; this version assumes A2:A100 and that A2 is the first cell in the Applies to range.

How the formula and relative references work

In a conditional formatting formula, Excel evaluates the expression separately for each cell in the Applies to range. The reference A2 is relative: when Excel evaluates the rule for A3, it checks A3; for A4, it checks A4, and so on. That is why the formula uses the first cell in the selected range rather than a fixed reference to the entire range.

If the rule is applied to A2:A100 but the formula begins with A1, each result will be offset by one row. The formatting may appear to respond to the date in the row above, a confusing symptom that is often caused by a mismatched starting reference. If the selected range starts at D5, use D5 as the relative reference in the formula.

When the date is in one column but you want to highlight an entire row, select the rows’ full data range and lock the date column while leaving the row number relative. For example, if dates are in column C and records occupy A2:F100, use =AND(ISNUMBER($C2),$C2>TODAY()); this assumes the Applies to range is A2:F100 and each row’s date is in column C. The dollar signs keep the test in column C as the rule moves across the row, while the row number changes for each record.

Choose the right version for dates with times

Decide whether “after today” refers to a future calendar day or any point in time later than the current day’s midnight. For cells that may include times, those definitions can produce different results. If a timestamp from today should not be highlighted, compare only its date portion by using INT.

For timestamps in A2:A100, with A2 as the first cell in the Applies to range, use =AND(ISNUMBER(A2),INT(A2)>TODAY()). INT removes the fractional time component from an Excel date-time serial value before the comparison. A timestamp from today then compares as today and is not highlighted, while a timestamp on a later date is.

If instead you intend to highlight anything later than the start of today—including appointments later today—the basic comparison against TODAY() may be appropriate. The choice is about the meaning of the rule, not an error in Excel. For a deadline tracker, date-only behavior is often easier to interpret; for a schedule of upcoming times, time-sensitive behavior may be what you want.

Use the built-in date rules or a formula?

Excel’s Conditional Formatting menu includes date-oriented options under Highlight Cells Rules > A Date Occurring. Those preset choices are convenient for common periods such as today, yesterday, tomorrow, or a named recent or upcoming period shown in the menu. They are useful when a preset period matches the question you need to answer.

A formula rule is generally the better fit when the requirement is specifically “any date strictly after today,” with no fixed end date. It also gives you control over blanks, time values, and whether today counts. A preset such as Tomorrow identifies a narrow period; it does not mean every future date. Check the available choices in your Excel version if you are considering a preset, since a menu option for a particular period is not a substitute for an open-ended future-date test.

For a one-off visual check, sorting the date column from oldest to newest or filtering for dates after a chosen date may be enough. Conditional formatting is more useful when the sheet changes regularly and you want future items to remain visible without manually reapplying a color each day.

Keep the rule current and manage its range

TODAY() is a volatile date function: its result can update when Excel recalculates the workbook. That makes it suitable for a rule that should track the current date rather than a date permanently typed into the formula. Excel’s calculation settings affect when formulas recalculate. If a workbook uses manual calculation, changes in the displayed rule may not appear until recalculation; press F9 on Windows to recalculate formulas.

Conditional formatting does not permanently color a cell. It displays the chosen format when the rule evaluates as true, and the appearance can change as the date advances or the cell value changes. A date that is in the future now can stop being highlighted after it becomes today, because the condition is strictly after today.

Check the Applies to field when new rows are added. A rule applied only to A2:A100 will not necessarily cover dates entered in A101 and below. You can edit the range in Home > Conditional Formatting > Manage Rules, or apply the rule to a larger range if appropriate. Converting the data to an Excel table can also help keep structured data and formatting consistent as rows are added, though you should confirm that the rule’s Applies to range includes the new rows.

Common problems and practical checks

  • Nothing is highlighted: Confirm that the cells contain real Excel dates, not text that only looks like dates. Check the first-cell reference and the Applies to range, and verify that the dates are actually later than the computer’s current date.
  • The wrong row or cell is colored: Make sure the formula refers to the top-left cell of the Applies to range. For a whole-row rule, lock the date column with a dollar sign, as in the column C example above.
  • Blank cells are highlighted: Use the ISNUMBER version of the rule. A cell that appears empty may also contain a formula returning an empty string or other content; verify what is actually in the cell.
  • Today’s timestamp is highlighted: If only future calendar dates should count, use INT(A2) in the comparison as shown above. The plain comparison treats a time later than midnight today as greater than TODAY().
  • A date-looking value does not match: It may be stored as text, or it may have been interpreted differently when imported. Convert it to a real date value before relying on numeric date comparisons. Changing the cell’s number format alone changes its display, not necessarily its underlying value.
  • The result seems stale: Check whether calculation is set to Automatic under Formulas > Calculation Options. If calculation is manual, recalculate the workbook and check again.

Also review other rules on the same cells. In Manage Rules, confirm the order and ranges of overlapping conditional formatting rules. A later or higher-priority rule may make a cell look different from the format you selected; the formula can be correct even when another rule controls the visible appearance.

Excel for Mac and Excel for the web

The formula logic is the same in Excel for Microsoft 365 on Mac: TODAY(), AND(), ISNUMBER(), and INT() work the same way. The ribbon layout can vary slightly by platform or update, but look for Conditional Formatting and the option to create a formula-based rule. The steps above use the Windows ribbon path.

Excel for the web also supports conditional formatting, though its available controls and dialogs may differ from the Windows desktop interface. If you cannot find the formula-based rule controls or need to manage a complicated set of overlapping rules, open the workbook in the desktop app. If a keyboard shortcut is useful, F9 recalculates in Windows Excel; on a Mac, recalculation shortcuts can depend on the keyboard and Excel settings, so use Formulas > Calculate Now or the relevant command shown in that version.

Frequently Asked Questions

How do I highlight dates greater than today in Excel?
Select the date range and create a formula-based conditional formatting rule using =AND(ISNUMBER(A2),A2>TODAY()), adjusting A2 to the first cell in the selected range. Choose the appearance you want in the Format dialog.

Does Excel’s TODAY() function update automatically?
TODAY() can update when Excel recalculates the workbook. With Automatic calculation enabled, it normally refreshes as the workbook recalculates; in Manual mode, recalculate the workbook to refresh date-dependent results.

How can I include today’s date as well as future dates?
Change the comparison from greater-than to greater-than-or-equal. For dates in A2:A100 with A2 at the top of the Applies to range, the formula is =AND(ISNUMBER(A2),A2>=TODAY()). This includes today and later dates, though timestamps later today also qualify.

Why does conditional formatting highlight a blank cell?
Use an ISNUMBER check so the rule applies only to numeric date values. Also check whether the cell contains a formula or hidden content rather than being genuinely empty, and verify the rule’s Applies to range.

Can I highlight an entire row based on a future date?
Yes. Select the full data area and use a formula that locks the date column but keeps the row relative. For dates in column C and data in A2:F100, use =AND(ISNUMBER($C2),$C2>TODAY()).

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.