#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Select A1:A100
Ribbon: Home tab, Styles section, Conditional Formatting ,choose New Rule… Choose Use a formula to determine which cells to format Enter this formula: =$A1-TODAY()=3 click the Format… button and format as you want it to appear Click OK twice |
#3
|
|||
|
|||
Thank you very much for your help. It's much appreciated.
It looks as though this formula is formatting a cell if it is 3 days prior to whatever today's date may be. I actually could have several different dates in the range of cells and want it to change format if the date is 3 days prior to whichever date is in the cell. Not sure how this is done. Your help is greatly appreciated. |
#4
|
||||
|
||||
So this is wrong (the offering I made earlier)?:
(Can't attach a picture so a link) Dropbox - 2020-04-13_105333.jpg |
#5
|
|||
|
|||
P45Cal,
Thank you again for your help. Prior to applying the conditional formatting rule you gave me, I had another one applied to shade every other row. I used the following conditional formatting rule/formula: =MOD(Row(),2 Now because of my shading rule, the dates do not highlight on the shaded rows. Do you know if there's a work-around so I'm able to use both rules? Thank you in advance. |
#6
|
||||
|
||||
Attach a sample workbook with this and I'll adjust the conditional formatting.
|
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 |