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.
 
Back
Top