Expressions , change Background colour based on range

[#1]

Hi guys

I have  bar chart and I want the colour of the bars to change, dependant on the value.

So on the expressions tab, in Background colour if result is Less that 45, Orange, BETWEEN 45 and 50 go Green and greater than 50 go red.

I have tried the below, and it does not go red at all.

Can anyone see where my issue lies?

Thanks

A

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<45, RGB(255,128,0),

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])>45, RGB(0,191,0),

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<50, RGB(0,191,0),

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])>50, RGB (255,0,0)))))

[danielrozental · Accepted solution]

Try

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<45, RGB(255,128,0),

if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<50, RGB(0,191,0), RGB (255,0,0)))

[#3]

Thanks Daniel