5 Replies Latest reply on Aug 28, 2018 8:49 AM by Martin Bohlmann

    Conditional Formatting Cell Background Colour...!!!

    Venkat N



      I have forecast values being displayed as different colours and I want to color those values based on certain thresholds on Single Column like it should be Green if its value greater than 100 and less than or Equal -100% and Red and  Greater than -100 So I created a calculated field. Please find the below Examples.


      Kindly share some examples and suggestions.


      If [Diff] >= 100 THEN "Green"

      elseif [Diff] <= -100 THEN "Red"

      elseif [Diff] > -100 THEN "Yellow"