3 Replies Latest reply on Oct 17, 2016 1:59 PM by Eshwar Prasad

    Color Coding in the Text table

    Eshwar Prasad

      Hi Team,

       

      i have text table like below. I need to color columns conditionally.

       

      which column( either one fom 30th to 90th columns) is having equivalent value to the Rate% then that column should be Color Coded based on some condition like below.

       

      if [Value]> =80 then"green"

      elseif [value]<80 and >30 then "Yellow"

      elseif [value]<=30 then "Red"

      end

       

      for example for AAAAAAAA Rate% is 91.15, and equivalent value or near value for that(91.15) is there in 90th (91.67) . so this value should be highlighted with Green color.

       

      And BBBBB Rate is 22.83% and equivalent value or near value for that(22.83) is there in 80th (20.00) . so this value should be highlighted with Red color

       

      I hope my requirement is clear.