Conditional Formatting (modified date not in the last 3 weeks)

I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks.

So any row that has not been recently updated (last 3 weeks) should be highlighted in yellow.

Is this spmething that can be done directly within conditional formatting or should I first create a helper variable?

Thanks.

Find more posts tagged with

Conditional Formatting

Accepted answers

Carson Penticuff

There is no direct way to do this. Adding a checkbox helper column with something similar to this and then formatting based on the checkbox is the simplest way. You can even hide the extra column, as there is no reason for it to be visible.

=IF([Modified Date]@row < TODAY(-21), 1, 0)

All comments

Carson Penticuff

=IF([Modified Date]@row < TODAY(-21), 1, 0)

Jef Snyders

Thanks so much, Carson, for your quick reply.

This is super clear and answers my question.

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.