Conditional formatting items more than X number of days past due


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
    Bassam Khalil ✭✭✭✭✭✭
    edited 02/04/21

    Hi @Shannon Matter

    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

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Shannon Matter

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