Formula that Recognizes a Cell's formatting
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!
Answers
-
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".
-
Interesting solution. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!