Conditional Formatting in Excel tables

Hi, I am a complete novice to conditional formatting. I have managed to set some rules successfully, but have no idea how to do this one. I have a table based on the dates events have taken place. T...

excel

Formulas and Functions

OlufemiO
Jul 30, 2025
How to Automatically Highlight Past Event Dates (Older Than 3 or 6 Months)
Hi Excel Community,
I highlighted rows in the events log once the date becomes 3 or 6 months old.
so I used Conditional Formatting with formulas (no VBA).
🧪 Sample Table:
Date
Event
Location
01/12/2024
Workshop
London
10/01/2025
Launch Day
Lagos
15/03/2025
Webinar
Online
01/05/2025
Demo
Nairobi
15/06/2025
Training
Accra
10/07/2025
Networking
Cape Town
Goal: Highlight rows where the date in Column A is more than 3 months ago.
Steps:
Select your full table (A2:C10)
Go to Home > Conditional Formatting > New Rule > Use a Formula
Use this formula for 3 months ago:
=AND(ISNUMBER($A2), $A2 < TODAY() - 90)
Format with strikethrough or light gray fill
Click OK
🗓️ Use this formula for 6 months ago:
=AND(ISNUMBER($A2), $A2 < EDATE(TODAY(), -6))
📷 Screenshots included below showing setup and result.
[Setup Screenshot – Table View]

2. [Result Screenshot – Highlighted Past Dates]

OlufemiO

Brass Contributor

Jul 30, 2025

How to Automatically Highlight Past Event Dates (Older Than 3 or 6 Months)

Hi Excel Community,
I highlighted rows in the events log once the date becomes 3 or 6 months old.

so I used Conditional Formatting with formulas (no VBA).

🧪 Sample Table:

Date	Event	Location
01/12/2024	Workshop	London
10/01/2025	Launch Day	Lagos
15/03/2025	Webinar	Online
01/05/2025	Demo	Nairobi
15/06/2025	Training	Accra
10/07/2025	Networking	Cape Town