Global Background Colour with individual Overide Text Boxes

Hi aivoryuk,

As per my understanding, I think the expression you post is simple way. If you don’t want to use IIF function, I suggest we can try to use switch function as below to achieve the similar requirement:

=Switch(Fields!Bill_Rate.Value = 115,"Red",Fields!Number_of_Defendants.Value = 1 ,"Yellow")

If there are any other questions, please feel free to ask.

Thanks,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support