9 Replies Latest reply on Jul 28, 2016 6:02 AM by John Sobczak

    Color coding

    Eshwar Prasad

      HI Team,

       

      Thanks for your support.

       

      I have one requirement regarding color coding..

       

      i have a text table with more 6 columns. Int he one item count column i should show in the middle of the table.

       

      Now the requirement is, i need color code the values in the item count column based on the condition like below..

       

      if [Item count]<=5 then "Red"

      ELSEIF [Item count]>5 and [Item count]<= 20 then "Blue"

      ELSEIF [Item count]>20 then "Green"

      end

       

      But when i am placing this calculation in the color only spending amount is getting effected with colors. but i need to color code only item count..