1) Select the field to which you want to add conditional background color and press F4 to open the properties window.
2) Then CLICK on the dropdown box next to BackgroundColor and select Expression.
3) In the new window, Write following expression :
=iif(value = something, "Black", "Red")
BackgroundColor will be "Black" if value = something condition is true
else it will be "Red"
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQLPlease visit... ApplyBI