2 Replies Latest reply: Jul 5, 2016 4:08 AM by Dafnis X RSS

    NPrinting Excel Row color based on a field value

    Dafnis X

      Hi,

       

      I have created an Excel Pivot table based on the helpful tutorials..

      My question is:

      1. How do I change a range defined for a Pivot table in the source sheet? Looks like It's not possible...

      2. I would like to define the font color of the Excel table based on a value of a field in the straight table:

      for example: if the value is , then the font should be red. otherwise - black.
           Couldn't figure how to do it

       

      Thanks!