8 Replies Latest reply: Sep 14, 2017 6:15 AM by Anil Babu Samineni RSS

    Highlight Certain Fields

    jamal jimmy

      Hi,

       

      I am having an issue highlighting certain fields in my pivot table.

      I have a dataset like this.

      % of cars

      1

      2

      3

      4

      5

      6

      7

      8

      9

       

      I am using the following IF statement to arrange them into groups within the pivot.

      =if ([% of Cars] <5, '<5%',

      if ([% of Cars] <=7  , '6-7%',

      if ([% of Cars] <=8 , '7-8%',

      if ([% of Cars]  <=9, '8-9%',

      if ([% of Cars]  <=10, '9-10%',

      if ([% of Cars] >10, '>10%',

      ))))))

       

      The script works fine in sorting them into their designated fields. However I would like certain fields such as the <=10 and >10 to be in Red. I would like <5 and <=7 to be green. Does anyone know how to achieve this? I have tried for quite a while and I can not seem to find a solution.