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

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.
 
L

Luke M

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