Formula that Recognizes a Cell's formatting

Berto_DA

Is there such a thing? If a cell has a fill color of Red, can a formula read that cell and recognize that fill color? Same question for any kind of cell formatting - strikethroughs, font color, bold, italic, etc.?

The reason for the ask is that I have a plan that has A LOT of conditional formatting, and I want a report that will filter only rows that have particular conditional formatting (that formatting is defined by specific conditions - obviously). This will allow me to provide specific views of rows that meet specific criteria AS REFLECTED in their conditional formatting.

Let me know what you all think!

Thank you Smartsheet Community!

Paul Newcome

You would need to create a formula that outputs something specific for each rule that essentially reflects your conditional formatting. Formulas cannot read formatting, but if your conditional formatting rule is to "strike through" if a status is equal to "Cancelled", then you would write a formula (or just create a filter) based on the Status being "Cancelled".

Berto_DA

Interesting solution. Thank you.