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

    Same condition formatting for different calculated field

    Claire Chen



      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,