7 Replies Latest reply on Aug 30, 2018 10:48 AM by Ryan Skene

    Conditional formatting with parameters

    Ryan Skene

      Hello,

       

      I'm using a parameter to show sales units for different time frames/comparison periods and want to use conditional formatting for the comparison periods, but not absolute data.  Three of the periods are absolute figures (2017 actual units, 2018 actual+outlook units, and 2018 plan units), while two are comparisons (2018 vs 2017 and 2018 vs 2018 plan).  I don't want the absolute figures to have conditional formatting, but I want the comparisons to be conditionally formatted (green & red) based on whether they're better or worse than the comparison period.  Is there a way to conditionally format specific parameter controls, while not using conditional formatting for others?

       

      Input would be greatly appreciated.

       

      Thanks,

       

      Ryan