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

[#1]

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

[#2]

Hi Darek

I see that you can solve complex problem. 

I used to be quite often ask for advise. Only I have stop about 6 nth.  I never remember I see your name. 

Abt your question is am not sure what you mean ? But I guess you are asking me am I able create an new col to indicate red or green ??? Better you phase your question again. 

Paul

Sent from Samsung Mobile