Share via

Conditional formating a date occurring within the next 3 months.

Anonymous
2014-10-06T15:07:35+00:00

In column N I have end dates of training periods listed. Theses end dates are always on the last day of an individuals birth month, so every person (rows) end date is different. I want the end date to hightlight yellow when todays date is within 3 months. (example: end date is 31 Dec 14, I want it to highlight yellow on 01 Oct 14). I also want the end date to highlight red when thodays date is within 15 days.

Microsoft 365 and Office | Excel | For home | 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

Vijay A. Verma 104.9K Reputation points Volunteer Moderator
2014-10-06T17:42:45+00:00
  1. Select the range starting with N1
  2. Home tab > Conditional Formatting > New Rule > Use a formula to determine which cells to format and put following formula and select Red Fill Colour

=AND(N1-TODAY()<=15,N1<>"")

  1. Put following formula for Yellow Fill Colour

=AND(TODAY()>=EDATE(N1,-3),N1-TODAY()>15)

Was this answer helpful?

10+ people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-10-07T14:07:43+00:00

    Thank you. These formulas did the job.

    Was this answer helpful?

    0 comments