1 Reply Latest reply: Jun 30, 2017 5:35 AM by Kaushik Solanki RSS

    How to write expression for Back ground color in Pivot table

    Rajesh Chamarthi

      We have taken below data in Pivot table and wanted to give three back ground colors based on the Top and bottom columns for each row.Suppose if taken one row as example, Value between 82.4 and 80.4 ( i.e 82 ) should be displayed as yellow background, value greater than 82.4 and 80.4 (i.e  82.7) should have green back ground , values less than 82.4 and 80.4 (i.e 76.4,80.2,76.5,77.5,78.9 and 78.4) should have red back ground

       

      Could you please suggest how to write an expression for back ground color to appear as above

       

       

      Section12345678TopBottom
      A76.482.78280.276.577.578.978.482.480.4
      B7886.687.882.379.381.881.880.684.382.3
      C69.367.372.460.56563.663.660.67068

       

       

      Thanks
      Rajesh