Is there a way to have a cell match the conditional formatting the referenced cell has?

I'm creating a sheet where each cell is referencing a different cell on a master sheet. In the sheet I'm creating, is it possible to have the populated information in each cell match the conditional format from its reference cell?

Example: In the master sheet, if the cell contains a date that is in the past - it turns the text green. I want that date it pulls over to also be green in the summary sheet.

Find more posts tagged with

Conditional Formatting

Accepted answers

All comments

KPH

I believe you would need to recreate the conditional formatting rules on the summary sheet.

I had a quick look at the enhancement requests to see if this feature had been mentioned and found this, you could add your voice and use case to this request:

https://community.smartsheet.com/discussion/113740/template-themes-for-conditional-formatting?_gl=1*msnxgo*_ga*ODg5NjQzNTkyLjE2OTg1MjAzNzM.*_ga_ZYH7XNXMZK*MTcwNzE3NjgwMC4yNjAuMS4xNzA3MTgwMzc0LjMwLjAuMA..

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.