Conditional formatting between range of numbers
I have 5 line items (Number Formats) showing variances. I want to apply a conditioner formatting to each of the 5 line items based on a range of numbers.
E.g any numbers between -1500 to 2500 should have a Green colour and any numbers outside these range should get a RED colour .
Please is there any workaround to achieve this?.