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

    Color Formatting for Calculated Difference




      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.





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


      Thank you!