@Conditional formatting of Date

%3CLINGO-SUB%20id%3D%22lingo-sub-1412217%22%20slang%3D%22en-US%22%3E%40Conditional%20formatting%20of%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1412217%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20a%20sheet.%20I%20need%20the%20date%20to%20turn%20red%20if%20it%20happened%20over%201%20year%20ago.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1412217%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1412255%22%20slang%3D%22en-US%22%3ERe%3A%20%40Conditional%20formatting%20of%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1412255%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F677172%22%20target%3D%22_blank%22%3E%40DDDJohnson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20apply%20such%20rule%20to%20the%20column%20with%20dates%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20512px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193964iFFF99B99F55645F1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I need help with a sheet. I need the date to turn red if it happened over 1 year ago.

2 Replies
Highlighted

@DDDJohnson 

You may apply such rule to the column with dates

image.png

Highlighted
It's not really clear how you want to handle leap years (would 5/22/19 be considered over a year ago as it is 366 days ago, or not)?

If you want to ignore leap years, then you might tweak Sergei's formula to
=((TODAY()-EDATE(C2,12))>0)*(C2>1)