I am trying to format the colours within my google sheet based on the previous columns value. I have tried to implement it with conditional format rules but the results are inconsistent and not reflecting the correct colours.

I have tried to apply a custom formula for positive numbers =(D3-C3)>0 and =(D3-C3)<0 for negative. This results in what is shown in the image. I'm not sure if it is because of the range?

CodePudding user response：

try:

=($D3-$C3)>0

and:

=($D3-$C3)<0

update: