Forum Discussion
Colour date cell older than 1 year.
Hello Community,
Can you colour a date cell if it's older that one year from today?
I can find 'Last Week' and 'Last Month' but nothing for older that 1 year from today's date or 'Last Year'). Thank you.
For that you need to create a custom CF rule based on a formula, as shown in the example in the picture below.
Thank you much, I figured it was a custom, but wasn't sure of the formula, so thank you for including that. Have a great day.
