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

    Color cell by difference

    jiayi zhang



      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.