Help with Conditional Formatting Please

[emmykav]

Hello,

I am really struggling to make this work.

I need a conditional formatting formula that does the following: Turn the cell red when the number is greater than or equal to 2000, and turn green if it's less than or equal to -2000. Mine isn't working. The red is part way there, however highlights all numbers greater than or equal to 2000 or -2000.
green=ABS(O3)<=-2000
red
=ABS(O3)>=2000

Please can you tell me what I'm doing wrong?

Thank you!

Em

<tbody>
</tbody>

 

[Peakey123]

Edit: Sorry notices a flaw in my thinking

 

[Erik48]

I think your error lies in the fact you are making both values absolute (ABS). Therefore excel cannot make a difference any more between the two values.

 

[emmykav]

Hi Erik48, so how would you correct, as the red formatting isn't working correctly either?