1 Reply Latest reply on Apr 20, 2018 7:56 PM by swaroop.gantela

    Compare values between two tables and highlight higher value

    Jan Horcicka

      I have two tables that use the same data source but have different filters applied to them so they show different values. I would like to compare percentages between these tables and for each particular cell highlight the higher percentage by coloring it green and coloring the lower percentage red. As you can see in the image, I want to compare row 1 in column 1 in the first table against row 1 in column 1 in the second table. If the value is higher than in the second table (43% > 33%) I want it green, otherwise I want it red. (Highlighting example given for the first three rows). The same goes for all the other rows and columns. 47% > 9%, 41% > 23%, etc...

       

       

      Is there a way to do this?

       

      Thanks.