2 Replies Latest reply on Jun 29, 2016 2:34 PM by Claire Chen

    Same condition formatting for different calculated field

    Claire Chen

      Hi,

       

      Here's my quesiton. I want to color formatting these three columns based on the same condition (color green if delta >0 and color red if delta < 0 )

       

      All of the columns are calculated field I made and right now I'm using IF [Q1 Delta] > 0 THEN "up" ELSE "down" END to color Q1 Delta.

       

      But I don't want this calculatio field also color Q2 Delta and 2016 Delta. For instance, in the first row Q2 Delta should be in color green.

       

      Thank you.

       

      Warm Regards,

      Claire