Conditional formatting with dates

Erica Cole

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

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