13 Replies Latest reply: Oct 16, 2014 8:39 AM by Ruben Marin RSS

    Highlight fields in pivot table

      Hi guys,

       

      I have a pivot table with some numerical values and I need some formula in order to highlight them either green or red. What I need to do is to calculate if the numbers in the rows under the first one (the first row stays in place and it's always green) are either +- 5% of the number in the first row that's above it. How do I do this?

       

      Thanks,

      Adrian

       

      PS: I have the free version, so I'm not able to open any file.