Forum Discussion
Conditional Formatting in Excel tables
- 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]
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]