| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i get a date to turn red if it is within 90 days of today?
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
|
|||
|
|||
|
how do i get a date to turn red if it is within 90 days of today?
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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
