Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JonnyP-SC" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Formula for number of days between a date and today | Excel Discussion (Misc queries) | |||
How do I insert a date that is always 7 days in advance of today | Excel Discussion (Misc queries) | |||
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY | Excel Worksheet Functions | |||
How do I add a range by date over 90 days older than today | Excel Discussion (Misc queries) | |||
how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) |