date management

New Contributor

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. 

1 Reply

Found 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 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies