In Excel: select the dates, press Ctrl+1, choose Date or Custom, and apply a format such as m/d/yyyy, dd-mmm-yyyy, or yyyy-mm-dd.
Select the date cells.
Press Ctrl+1 to open Format Cells.
Choose Date for built-in formats or Custom for a pattern like yyyy-mm-dd.
If nothing changes, convert the values from text to real dates first.
What this does
Date formatting changes how a stored date is displayed, not the underlying serial number. That distinction matters: a real Excel date can show as 6/1/2026, 01-Jun-2026 or 2026-06-01 without changing its value. Text that only looks like a date must be converted first before number formatting will work. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. Treat “excel conditional formatting dates” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a workspace setting that makes a big sheet comfortable to navigate into a method you can reuse, explain, and defend when the workbook leaves your screen.
A worked example
A2 contains the real date June 1, 2026. Press Ctrl+1, choose Custom, and type yyyy-mm-dd: the cell displays 2026-06-01 while formulas still treat it as the same date. If A2 contains text like 01.06.2026 that Excel does not recognize, use Text to Columns or DATEVALUE first, then format it. Clean date formats make sorting, filtering, lookup formulas and reports trustworthy. They also stop ambiguous month/day values from being misread across regions. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. Here is the takeaway for “excel conditional formatting dates”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.
Common mistakes
- Trying to format text values that are not real Excel dates.
- Using mm when you meant minutes in a time format, or m when you meant month in a date context.
- Changing display format and expecting the underlying date value to change.
- Mixing regional date orders such as 03/04/2026 without clarifying whether it means March 4 or April 3.
Frequently asked questions
What is the ISO date format in Excel?
Use the custom format yyyy-mm-dd, for example 2026-06-01.
Why will my date format not change?
The value is probably text. Convert it to a real date with Text to Columns, DATEVALUE or a locale-aware import step.
Does changing format change the date?
No. It changes the display. The stored serial date remains the same unless you transform the value itself.
Other ways people ask this
People reach this page typing “date conditional formatting excel”, “excel conditional formatting date”, “excel conditional formatting for dates” and “conditional date formatting in excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “date conditional formatting excel”, “excel conditional formatting date”, “excel conditional formatting for dates” all point at the one operation explained on this page, which is why they all lead here.