Conditional Formatting on range of negative numbers

[nikeshv]

Hi Everyone,

I have a range of negative numbers and I want to set the background color of the values based on the group. I tried using conditional formatting features but I can use the feature only on positive numbers and having a tough time using it on negative numbers.

Example:

-1 to -10 -> Blue

-11 to -20 -> Green

-21 to -30 -> Red

Sample Dataset

City	Number
London	-12
Miami	-16
Bangalore	-29
Chennai	-06

[pranit828 · Accepted solution]

HI @nikeshv 

Check this conditional formatting rule.

[nikeshv]

@pranit828 

Thanks that worked for me, I had done the same thing but my number was interchanged so it was throwing the error.