1 Reply Latest reply on May 16, 2018 2:26 PM by Yuriy Fal

    Color cell by difference

    jiayi zhang

      Hi,

       

      I would like to color the cell (not the entire row or column) by the difference between the current record and previous record.

       

      Here is how the data set looks like:

       

      For each row, if the newest record (larger number) is different than the older record, color the newest number. It will look like following:

       

      However, I did above chart using 3 different sheets, one for each column. It then loses the sorting ability and might cause mis-alignment.

      Does anyone have better solution? Attached is the workbook.

       

       

      Thanks!
      Jiayi