Conditional Formatting

V.Cornwall

I am trying to add conditional formatting to a Date column so that it goes red if the date is -90 days ago or older from today but the conditional formatting (below) is only formatting -90 days from today as red.

Today date 24/10/2024 minus 90 days is 26/07/2024. I need every date before 26/07/2024 to go red and every date after 26/07/2024 to have no format also I need this format to continue each day.

I hope this make sense and someone can help, Thank you.

Paul Newcome

You would simply use

=IF([Date Column Name]@row <= TODAY(-90), 1)

Paul Newcome

There is a solution here:

https://community.smartsheet.com/discussion/130674/conditional-formatting-for-past-dates

V.Cornwall

@Paul Newcome thank you for your reply.

I have read your answers but I am still new to smartsheets and not sure how to change the formula to meet my requirements, please can help with it?

Below is the column that I need to conditional format so it goes red if the date is -90 days ago or older from today, I have added the helper column but I really don't know how to do the rest.

Paul Newcome

You would simply use

=IF([Date Column Name]@row <= TODAY(-90), 1)

V.Cornwall

@Paul Newcome Thank you very much that has worked

Paul Newcome

Happy to help. 👍️