Allow Multiple layers of Conditional formatting with more flexible color options
Let conditional formatting options be stackable in layers (similar to MS Excel). In my current model we have a table that uses color across all cells based on the development stage. At times we also want to color cells that have an error to a particular color of red, however this is not possible without stackable conditional formatting.
Also enable the color formatting options that show up in chart options for conditional formatting. The current formatting forces a small range of color options and certain colors cannot be used together. Allow the model builder to select the 3 colors that go in the conditional format gradient in any order the like.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!