date management

[MJulius26]

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. 

[#2 · Accepted solution]

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