How to write the expression to change the background colour based on parameters any can give me the syntax thank you.

try the following paste it in the background property on the property page of the text box or whatever =iif(1=0,"White","Red") there is even an option of expression editor as the first color in the dropdown of the background property -------------------------------------------------------- Surender Singh Bhadauria

Hi, 1. Select the cell where you want to change the background color and click F4. 2. You can see properties pane in the right side. 3. In the go to the BackgroundColor and select expression and paste the below expression. =IIF(Parameters!PName.Value = "SomeValue", "Green", "Red") Hope its clear & helpful.... Pavan Kokkula Tata Consultancy Services.