May 28 2019 04:29 AM
Hello, community,
I have a problem to which i don't have an answer for.
I'm trying to manage dates with colors. I need to mark the date (in yellow) if the date is past TODAY, and mark the date (in red) if it's 5 years ago from today.
For example 2019-05-28 (yellow); 2019-05-29 yellow)................... 2024-05-29 (red), 2024-05-30 (red), 2024-05-30 (red) and so on.
I hope my question is understandable (I'm not a native English speaker).
Thank you in advance.
May 28 2019 05:25 AM
SolutionFound the answer. All i had to do is just use conditional formatting of few clicks away the cells with dates lights up.
Grater then =today() and grater then =today()+1825. @MJulius26
May 28 2019 05:25 AM
SolutionFound the answer. All i had to do is just use conditional formatting of few clicks away the cells with dates lights up.
Grater then =today() and grater then =today()+1825. @MJulius26