reporting services - How to change color of the font based on the thresh hold value -

reporting services - How to change color of the font based on the thresh hold value -

i have requirement if the threshhold value greater 6% text color should appear reddish , between 5-6% should alter yellow. tried look in text box font color property first requirement iif(fields!my_column.value>6, "red","black") did not work. appreciate tips both of problems.

no reason shouldn't working.

you can set color property text box , should fine.

=switch(fields!my_column.value > 6, "red" , fields!my_column.value < 5, "black" , true , "yellow")

gives:

how underlying info look? 6% "6" or "0.06"?

reporting-services fonts colors