1 Reply Latest reply on Jun 26, 2016 9:29 PM by lei.chen.0

    Text Table: Shading text red or green based on previous value

    Patrick T

      I have a text table with several measures on it. I would like to highlight text green if the current value of the measure is greater than the previous value, and red if it is less than.example.PNG

       

      Looking at the above, for column 'Dollars Made', I'd like the value '$43,274.00' at '2011 Q1' to be in red font because the previous value of '$45,789.00' is greater. For the 'Dollars Spent' column I'd like the value '$48,686.00' at '2011 Q1' to be in green font, because the previous value of '$44,829.00' is less than.

       

      How can I go about accomplishing this?

       

      Thanks