4 Replies Latest reply on May 19, 2016 4:38 AM by Mark Fraser

    Conditional Formatting Cell Background Colour...!!!

    Venkat N

      Hi,

       

      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"

      END