10 Replies Latest reply: May 17, 2014 11:42 AM by Paul Yeo RSS

    How to make my variance column 130.4% Green Back Ground change to Red ?

      Hi All

       

      I have an issue on above mentioned.

       

      My existing expression as below :-

       

      =If(Column(1)=0,1,(Column(2)-Column(1))/(Column(1)))

       

      I am not sure how to modify the above expression , if the value is -ve for Column(1) , need to change the Back ground color from Green to Red.

       

      In case Column(1) value is +ve value , there is no issue on the Back ground color.

       

      Paul