@Conditional formatting of Date

Copper Contributor

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

2 Replies

@DDDJohnson 

You may apply such rule to the column with dates

image.png

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)