Forum Discussion

sb1447's avatar
sb1447
Copper Contributor
Jul 29, 2025
Solved

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...
  • OlufemiO's avatar
    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:

    1. Select your full table (A2:C10)
    2. Go to Home > Conditional Formatting > New Rule > Use a Formula
    3. Use this formula for 3 months ago:

    =AND(ISNUMBER($A2), $A2 < TODAY() - 90)

    1. Format with strikethrough or light gray fill
    2. Click OK

    ๐Ÿ—“๏ธ Use this formula for 6 months ago:

    =AND(ISNUMBER($A2), $A2 < EDATE(TODAY(), -6))

    ๐Ÿ“ท Screenshots included below showing setup and result.

    1. [Setup Screenshot โ€“ Table View]

     

    2. [Result Screenshot โ€“ Highlighted Past Dates]

     

Resources