1 Reply Latest reply on Jul 17, 2018 10:24 AM by Andrew Bickert

    Conditional formatting on multiple measures

    John Thompson

      Need help doing conditional formatting on a table and can't figure out a calculation for color the table by the outlier I'm looking for.

       

      In my example, I'm looking at highlighting the themes that have a variance of greater than 3% or less than -3%.

      This is between the Theo % and Act % fields.