Second time again I have been caught in performing the dynamic formatting, though this is more kind of development type of question and I was searching through Reporting Services side. The issue is to change/highlight the color of a row, base on its value, in case if a column value is say greater that 90%, the cell should be red. You can achieve this by performing under Reporting Services by choosing the color property of the field: =iif(Fields!MyField.Value > 85, "Red", "Black") Also here's a...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/10/17/dynamic-formatting-report-question.aspx