8 Replies Latest reply: Apr 28, 2017 9:45 AM by Onno van Knotsenburg RSS

    Conditional Formatting - Rows comparison

    Sarah Mghames

      Hi,

       

      Can someone help me do the following conditional formatting:

      conditional formatting in pivot table by comparing each row to the previous one and color the cells accordingly. (multiple rows exist)

       

       

      If cell (I,j) > cell(I-1,j) --> red

      If cell (I,j) < cell(I-1,j) --> green

      else no format