Conditional Formatting

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.

Find more posts tagged with

Accepted answers

Paul Newcome

You would simply use

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

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.