Conditional formatting items more than X number of days past due

Shannon Matter · 02/03/21

Is there a way to set a rule for conditional formatting for rows where a due date is more than 45 days in the past?

Bassam Khalil · 02/04/21

Hope you are fine, you can create a helper column with the following formula

=TODAY() - [Due Date]@row

and create your conditional formatting rule using the helper column as reference. please check the following screenshot

Shannon Matter · 02/04/21

Thanks. I was hoping to be able to do it without a helper column, but it appears that's not possible.

Answers