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.
 

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

Conditional formatting with dates 7
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Formatting / Formula 6
Conditional Formatting 0
[Flashing] RED before renewal date 1
color coded dates 3
Conditional format to change row colour 1

Top