Conditional formatting with dates


I want to add conditional formatting that is triggered if a date is more than 2 days old. Which of these criteria should I select? Is this possible?


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 03/14/24

    Hi @Erica Cole,

    to do that you need to add a helper column call it "Remaining Time" for example and use the following formula in this column and convert it to column format formula:

    =TODAY() - [Submittal Date]@row

    then in conditional formatting use this condition ( "Remaining Time" is less than -2 )

    here is a screenshot shows the result

    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"