2 Replies Latest reply on Mar 14, 2016 8:49 AM by Tommy Sims

    Conditional color formatting from previous date

    Tommy Sims

      Hello,

       

      I am trying to format a report so that values in a column will be green if greater than the previous date column and red when they are less than the previous date. I would like the formatting to work for all measures in the first column. Also, the dates are exact date and are controlled with a parameter so that the user can switch between monthly and weekly. Does anyone have an idea of how this could be accomplished? Attaching a screenshot of an excel that attempts to show what I would like to achieve.

       

      Tommy