Conditional formatting between range of numbers

Monpero

Hi Anaplaners,

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?.

R_Goza

@innocent

You'll have to create a conditional formatting line item for each variance to achieve what you're looking for unless you create a line item subset. The logic would look something like the screenshots below whether you create conditional formatting line items for each variance or go the line item subset route . I would also recommend creating a Lookup or Reference module (like I have done) for your min and max ranges instead of hardcoding them in the formula. This will allow you to easily update the values if the ranges need to change.