Conditional Formatting of negative number for certain ranges

[Anonymous]

Hi Expert

How would you apply the CF rule to the following, i am getting a erro for -250 to < -500 and so on as shown

[Anonymous]

HI @Anonymous,

I think you are write the wrong conditions, -500 should less than -250, you may need to swap the two conditions operator of the last two rules.
Regards,

Xiaoxin Sheng

[benyhh]

The two last bounds include values that are in some of the other conditions as well. You can fix it by swapping -250 with -500, and -500 with -1000 in the two last rows.

EDIT:

If you swap the numbers, you will also need to swap some of the "<,>". The easiest might be to change it to

< -250 and >= -500

<-500 and >= -1000