5 Replies Latest reply on Aug 6, 2018 8:04 AM by Samuel Santos

    Exclude Nulls from Conditional Formatting

    Samuel Santos

      I have a Measure Values text table with a few conditionally formatted columns (via split color legends).  I've got the conditional formatting working as expected with one exception.  There are a few intersections where the value is BLANK/NULL and it takes on the color of whatever Zero is formatted as.  Here's an example.

       

      What are the best workarounds considering these key elements (which I can't change for this project)...  Measure Values Text Table, Split Color Legends.

       

       

      This is how it's currently setup...

       

       

      Thanks for any and all tips.