how do i get a date to turn red if it is within 90 days of today?

  • Thread starter Thread starter JonnyP-SC
  • Start date Start date
J

JonnyP-SC

I use a spreadsheet with lots of dates and need them to automatically turn
red if they are within 90 days of today's date. I believe I need to use
conditional formatting, but am not sure how to set it up correctly.
 
Correct, conditional formatting is the way to go. Set first box to "formula
is" then input:

=AND(TODAY()<=A2+90,TODAY()>=A2-90)

Note that this assumes you mean "within 90 days" to be plus or minus. If
not, remove the appropriate part of the formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

several conditional formats for dates 4
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
90 day tracking 1
color coded dates 3
Formatting / Formula 6
Changing the colour of a cell after a specific date? 0
Conditional format based off of a logical if statement 3
Conditional Format help 5

Back
Top