as u mentioned ,your issue is.
you are using this condition.
if column 1(sales target)- column 2(sales actual) is not equals to 0,then it should show red else it should show green.
now after that you wrote
but the problem is some difference values are in red and green.
(now as per your condition values will come in green and red only ,according to the condition.if target-sales=0 then it will show green and if target-sales is not equals to 0 then it will show red.)
is there any betr way to give any color to the difference.
I don't see any issue in this.
If you can explain your issue properly it will b gr8.