Conditional Formatting & Negative numbers

[Neobeowulf]

Team,

I'm having an issue with conditional formatting when it comes to negative numbers. It should be pretty straightforward but it's giving me problems. I checked to make sure the text box is set to a number and it is.

I have a text box with a calculated number in it.

If the number is greater than 0, I need the box red
If the number is between 0 & -5, I need the box yellow
If the number is less than -6, I need the box green.

However, when the number is 0, it turns yellow (which is fine) any other number whether positive or negative turns red.

Suggestions?

 

[bob fitz]

I'm not sure about this and have not tested it but maybe you need to include the calculation when you set the conditional format.

 

[bob fitz]

The calculation doesn't seem to be the problem. See attached file.

 

[Neobeowulf]

Figured it out. I had the text box set to number as it should be, the formatting was also correct.

The problem (as expected) was user error. Of all things I forgot to bind the box. :banghead: