Modified system column questions

Does Conditional Formatting trigger the Modified time stamp? I have a sheet that I want to highlight entire rows to a certain color if the Modified date was in the last 30 days, but every time I save the sheet the modified date would update to whenever I "saved". This is really a terrible design if it does.

Also, it looks like copying a row with automation from another sheet into this sheet somehow counts as modifying all the existing rows. Is that really how that works?

How can I highlight the entire rows with the parameters I listed above and copying rows from an intake sheet without triggering the Modified system column?

Editing to add:
It also looks like that the formula columns are somehow "modifying" when new rows are copied over? Can anyone explain?

Find more posts tagged with

Sheets

functionality

Accepted answers

All comments

Archiduc

"Does Conditional Formatting trigger the Modified time stamp?" → No I don't think so, but you can test this easily.

"every time I save the sheet the modified date would update to whenever I "saved"" → Maybve you have another column that uses the "today" formula? that has the tendency to force you to save and all the rows that have that formula will be updated.

"it looks like copying a row with automation from another sheet into this sheet somehow counts as modifying all the existing rows" → I'm not sure about that one, but I feel like that's not the case. There are a lot of things that can update the rows though, the cross sheet formulas, the automations, or data shuttle if you're using it too (or the today formula again).

You could use the automations to record a date when a specific cell(s) is changed and set up a conditional formatting based on that.

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.