When you click view the cell's properties in the property window, there should be a Background Color property. Then you can create conditions. e.g =IIF(Fields!Column.Value = "Approved", "Green", "No Color") Here is an example::
=iif(Fields!Date.Value < today() AND Fields!ID.Value = "a", "RED",
iif(Fields!Date.Value < today() AND Fields!ID.Value = "b", "BLUE",
iif(Fields!Date.Value >= today() AND Fields!ID.Value = "a", "GREEN",
iif(Fields!Date.Value >= today() AND Fields!ID.Value = "b", "YELLOW","WHITE"))))
This checks the date value of "Date" and compares it to today, as well as the text value of "ID" and compares it to "a" or "b".
If the text value is a and the date is before today, make the field red, if its b and before today, then make it blue. If the date value is today or later and the text value is a, then make it green and if the date value is today or later and the text value is b then make it yellow. If none of the conditions match, then make it white.
However when you have many conditions you might prefer 'switch' logic:
=switch( Fields!Date.Value < today() and (Fields!ID.Value = "a" or Fields!ID.Value = "c"), "red",
Fields!Date.Value < today() and (Fields!ID.Value = "b"), "blue",
Fields!Date.Value >= today() and (Fields!ID.Value = "a" or Fields!ID.Value = "c"), "green",
Fields!Date.Value >= today() and (Fields!ID.Value = "b"), "yellow")
etc
(Why not create the report in Excel which has such conditional formatting features?)
