Share via

Conditional formatting based on time since date in Excel.

Madeline Stedman 0 Reputation points
2025-05-02T03:07:26.14+00:00

I have a table where I keep track of applicants to our organisation. I have a column dedicated to when I first contact the applicant requesting documentation. I would like to format these cells to alert me when:

  • It has been two weeks from initial contact date (yellow)
  • It has been three weeks from initial contact date (orange)
  • It has been four weeks from initial contact date (red)

I understand I will need to go to Conditional Formatting > New Rule > Use a formula to determine which cells to format. However I can't quite get the formula or selection right.

User's image

Please help and thank you in advance!

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,880 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Barry Schwarz 3,736 Reputation points
    2025-05-02T06:01:10.5066667+00:00

    Assuming column D is dedicated to the dates in question, create these conditional format rules in order for the column

    =today()-d1>28
    =today()-d1>21
    =today()-d1<14

    Make sure to check the "Stop If True" box for each rule. You can also replace the > with >= if that matters.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.