Hi I am trying to make the background colour to change dependant on a valu changing , the expression below does not error , but doesn't give the correct background colour ? =IIF(Fields!QUOTATIONSTATUS.Value= "0","Beige","Beige")& IIF(Fields!QUOTATIONSTATUS.Value="1","Beige","Beige")&IIF(Fields!QUOTATIONSTATUS.Value="2" ,"PaleGreen","Beige")Kiwi_Wizz

Hello, Your actual expression looks like = IIF(Fields!QUOTATIONSTATUS.Value="0","Beige","Beige") & IIF(Fields!QUOTATIONSTATUS.Value="1","Beige","Beige") & IIF(Fields!QUOTATIONSTATUS.Value="2" ,"PaleGreen","Beige") and if e.g. the value is 1 then it will return "BeigeBeigeBeige", because for all 3 IIF a value is returned and concatenated by the &; not a valid color. I guess it's more like this want you want to perform: = IIF(Fields!QUOTATIONSTATUS.Value="0" ,"Beige" ,IIF(Fields!QUOTATIONSTATUS.Value="1" ,"Beige" ,IIF(Fields!QUOTATIONSTATUS.Value="2" ,"PaleGreen" ,"Beige") ) ) Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich Blog Xing

Brilliant , thanksKiwi_Wizz

If that's your logic for the background color then you can simplify it with: =IIF(Fields!QUOTATIONSTATUS.Value="2" ,"PaleGreen" ,"Beige")Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing