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

Options

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!