Colour conditional formatting for range

[kevalpatel26]

Hello, 

I would like to create an expression for cells within field I to display values:

1-35	Green
36-150	Amber
>151	Red

Thank you!

[Saravanan_Desingh]

May be,

If([Field I]<=35, Green(), If([Field I]<=150, Yellow(), Red()))

[kevalpatel26]

Thank you but unfortunately that doesn't seem to work, flagging up as 'error in expression'. 

Would you know why this expression is not working?

Pick(Match(I, '<=35', '<=150'), RGB(0,128,0), RGB(255,255,0), RGB(128,0,0))

[Gabriel]

Hi,

May be try

IF([FieldValueName]=1 AND [FieldValueName] <= 35,RGB(0,255,0) ,

IF([FieldValueName]=36 AND [FieldValueName] <= 150,RGB(255,191,0),

IF([FieldValueName]>= 151,RGB(255,0,0)

)))

[kevalpatel26]

Thank you Gabriel, there are no errors in the code when inputted. However when run it doesn't seem to change the background colour of the cell. 

[Gabriel]

Hi,

Which chart object are you using?

Let me replicate it