|
|
#1
04-09-2020, 04:10 PM
|
|||
|
|||
Conditional Format Dates Due in X Days
I have a range of dates in A1:A100. I would like to set up conditional formatting in the cell to change to light red fill with dark text if the date is 3 days prior to that date in the cell.
So, if the date is 4/17/2020, I want it to conditionally format the date/cell on 4/14/2020, so I know that it's due in 3 days. Your help is greatly appreciated. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula for calculating dates based on Business Days | jthomas666 | Excel | 2 | 03-02-2020 09:05 AM |
| Default How to automatically Calculate number of days between two dates? | wcngu1 | Word | 6 | 10-24-2019 04:20 AM |
 increasing dates across college timetable by 40 days
|
GavinHar | Word Tables | 2 | 03-15-2016 04:03 AM |
|
Calculating Quarterly Dates by Months not Days
|
Artboy34 | Excel | 3 | 01-28-2016 09:47 AM |
| Start / End Dates in conjunction with man days | loobs40 | Project | 5 | 09-19-2013 09:21 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode