4 Replies Latest reply on Jul 10, 2018 11:00 PM by Shinichiro Murakami

    Conditional Formatting based on Results of a Diff Quick Table Calculation

    Lindon Belshe

      Hi There,

       

      I have a sample worksheet attached. Essentially, I have written an LOD function to get the percentage of each type by group and date (aggregated to the monthly level). My question, which has some broad applications, is this: how can I most easily now have the ability to color based on the difference (percentage) between the two most recent months of the data (essentially what is shown on the attached file) - meaning if the two most recent months (in the data, not by calendar) are trending upwards, I want to apply a green color to other worksheets. I know the answer is going to be a calculated field building upon the LOD function that I can then through into the color marks tool when need, but any guidance on what that formula looks like would be great!

       

      Thanks!