Conditional formatting items more than X number of days past due

Options

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?

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 02/04/21
    Options

    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

    bassam.khalil2009@gmail.com

    ☑️ 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
    Options

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