Help using conditional formatting with a measure

[JorgiaM]

Hi everyone,

I have written a measure which I have linked to conditional formatting. So in a short explanation, if the value for my parameter is good it is coded with the number 1 and the cell is conditioned to turn green. If the value is bad it is coded with the number 2 and the cell is conditioned to turn red and if it needs looking in to it is coded with the value 3 and the cell turns orange. 

I am doing analysis of biological results in soil. All the AMN values that are red should be, but the values in total carbon and nitrogen etc should not be red they should be green. So some how it seems like it is linking with the first values in column one (AMN). Can any body provide an answer as to why? See attachments of my table and coding .

Thanks!

Jorgia 

[amitchandak]

@JorgiaM , You need to change the order like <= 20 should come before <=150 as 20 is also less than 150 so it will never reach that condition

order should be

<= 20

<=150

>150

[JorgiaM]

Thank you for your response. I have updated that but it is still showing red through the columns as before..