Dais Helper
New Member
- Joined
- Jun 11, 2020
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
I have a column full of various dates -- so far the oldest one is from 2017. I am allowed to get rid of these papers after four years. So 2021 in this case but not 1/1/21, whatever the exact date is or later I would be able to safely get rid of the paper.
So I want to highlight the cells as each one expires as they each reach their individual deadline in 4 years from the date listed in the column.
I found this formula in the forum and thought it would work, but it did not.
=DATEDIF(CD2,TODAY(),"Y")>=4
It highlighted a date clearly within 4 years -- like 2/6/20 & 10/14/19 --- it left some clear as it was supposed to then these chunks of column are highlighted. And it highlighted blank cells.
Is there a formula for conditional highlighting that I can use to highlight only if the date has reached 4 or more years; also do not highlight blank cells?
Is there a Formula that can do this. I really am not comfortable with VBA. It's not imperative that this occurs, so I can do without if VBA is needed.
Thank you very much for your time and assistance. ?
So I want to highlight the cells as each one expires as they each reach their individual deadline in 4 years from the date listed in the column.
I found this formula in the forum and thought it would work, but it did not.
=DATEDIF(CD2,TODAY(),"Y")>=4
It highlighted a date clearly within 4 years -- like 2/6/20 & 10/14/19 --- it left some clear as it was supposed to then these chunks of column are highlighted. And it highlighted blank cells.
Is there a formula for conditional highlighting that I can use to highlight only if the date has reached 4 or more years; also do not highlight blank cells?
Is there a Formula that can do this. I really am not comfortable with VBA. It's not imperative that this occurs, so I can do without if VBA is needed.
Thank you very much for your time and assistance. ?