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.
3 Comments
