Share via

Conditional Formatting for Dates

Anonymous
2025-02-05T12:06:57+00:00

Hello

I have a column showing a list of expiry dates, formatted as mmm-yy. I would like it to automatically format so that:

  • Any dates that are in the past are filled with red
  • Any dates that fall within three months from today are filled with orange
  • Any dates that fall within four and twelve months from today are filled with yellow
  • Any dates further into the future than twelve months remain unformatted.

I've tried to fathom out how to do this, but am failing miserably, so all advice gratefully received. Thank you.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2025-02-05T14:31:33+00:00

    Change all the $G2 to G15 as your first row of selected range is 15.

    1 person found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-05T14:44:38+00:00

    Thank you! I'm a Dunce! 🤦‍♀️

    0 comments