I have an expression
I am trying to color code the text
My value is a percentage
Below keeps the value to green
And it does not change
This is not working:
=IF(vUT%>=0.0 and vUT% <= 0.5, RED(),
IF(vUT%>=0.51 and vUT% <= 0.7, YELLOW(),
Can you use Square Brackets () around your expression. What does the expression for vUT% and how values are looks like?
=IF([vUT%] >= 0.0 and [vUT%] <= 0.5, RED(),
IF([vUT%]>=0.51 and [vUT%] <= 0.7, YELLOW(),
Im sorry pratyush i cannot,
the value stays green and does not change to red or yellow depending on what it is
i.e: If the percentage is lower than 50% it should be red
higher than 70% it should be green
It is giving green coz it is not satisfying any of the conditions above, try to use the variable in text. Capture its value and then try to check that in your condition.