SOLVED
Home

date management

%3CLINGO-SUB%20id%3D%22lingo-sub-651781%22%20slang%3D%22en-US%22%3Edate%20management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-651781%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20community%2C%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20to%20which%20i%20don't%20have%20an%20answer%20for.%3C%2FP%3E%3CP%3EI'm%20trying%20to%20manage%20dates%20with%20colors.%20I%20need%20to%20mark%20the%20date%20(in%20yellow)%20if%20the%20date%20is%20past%20TODAY%2C%20and%20mark%20the%20date%20(in%20red)%20if%20it's%205%20years%20ago%20from%20today.%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%202019-05-28%20(yellow)%3B%26nbsp%3B2019-05-29%20yellow)...................%202024-05-29%20(red)%2C%26nbsp%3B2024-05-30%20(red)%2C%202024-05-30%20(red)%20and%20so%20on.%3C%2FP%3E%3CP%3EI%20hope%20my%20question%20is%20understandable%20(I'm%20not%20a%20native%20English%20speaker).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-651781%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-651916%22%20slang%3D%22en-US%22%3ERe%3A%20date%20management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-651916%22%20slang%3D%22en-US%22%3E%3CP%3EFound%20the%20answer.%20All%20i%20had%20to%20do%20is%20just%20use%20conditional%20formatting%20of%20few%20clicks%20away%20the%20cells%20with%20dates%20lights%20up.%26nbsp%3B%3C%2FP%3E%3CP%3EGrater%20then%20%3Dtoday()%26nbsp%3B%20%26nbsp%3Band%26nbsp%3B%20grater%20then%20%3Dtoday()%2B1825.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349952%22%20target%3D%22_blank%22%3E%40MJulius26%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
MJulius26
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
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 

Related Conversations