Is there a conditional formatting rule that shows if a date is more than X years in the past?
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. I can only find the function for "in the past" without any way to add to the formula how far in the past. Is it possible to set parameters on past dates?
It seems like this should be a relatively simple conditional formatting rule and I'm guessing other people must have needed this as well, so I am hoping there's a solution. Thank you!
Help Article Resources
Check out the Formula Handbook template!