Formula to trigger red flag based on conditional formatting rules?
Is there a formula that will mark a flag red based on conditional formatting of other columns in a row?
For example, I've set up multiple conditional formatting rules within a tracker sheet. I'd like to have a checkbox column with a flag that would turn red if some of those conditions were met using conditional formatting rules.
Is this possible?
Answers
-
@HSabin (Turning a flag red sounds a lot like changing the value in a cell. That is not what conditional formatting does really. Did I misunderstand what you are trying to do?)
You could write a formula for your Flag column that replicated the rules of your conditional formatting rules. That is probably your best path.
dm
-
@Dale Murphy Thank you. I was hoping to use a formula to trigger the flag, but wanted to use the conditional formatting as the conditions. Sounds like that may not be possible. Was trying to avoid setting up the same "rules" in multiple places (conditional formatting, formulas in cells, etc.). Thank you for the quick reply.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!