3 Replies Latest reply on Dec 4, 2018 11:18 AM by phiphi.lau

    Color Formatting for Calculated Difference

    phiphi.lau

      Hi,

       

      I am working on a survey where I can compare the state and institution mean.  To see the comparison, I created a table calculation of the difference.  I want the state mean to stay black but the institution mean is colored based on the difference (institution mean is greater than state mean = blue, institution mean is less than the state mean = orange).  I was able to color code the institution mean but that is only if I the state row is above the institution row (see screenshot).  Since I am trying to highlight the institution, I prefer to have the institution mean on top.

       

      Screenshot:

      2018-12-04_10-55-21.png

       

      Any help, insight or alternative is greatly appreciated!  The workbook (ver. 10.5.3) is attached.

       

      Thank you!