How to create heat map on a table in SSRS?

Question

How can I create like this in SSRS? The color will change from red to green based on a value in a row (Underwriter). And all that in a group:

Answer 1

You can do this by right clicking on the individual cells and setting the fill colour based on an expression:

In the Image below I've mistakingly put "==" where it should be "="

To give you an example the following:

was created using the following expressions for the ID30, ID60 and ID90 fields respectively:

ID30:

=IIF(Fields!ID30.Value>="0" And Fields!ID30.Value<="100" ,"#c6c626",IIF(Fields!ID30.Value>="100" And Fields!ID30.Value<="200" ,"#c6c627",IIF(Fields!ID30.Value>="200","#9e2424","red")))

ID60:

=IIF(Fields!ID60.Value>="0" And Fields!ID60.Value<="100" ,"#c6c626",IIF(Fields!ID60.Value>="100" And Fields!ID60.Value<="200" ,"#c6c627",IIF(Fields!ID60.Value>="200","#9e2424","red")))

ID90:

=IIF(Fields!ID90.Value>="0" And Fields!ID90.Value<="100" ,"#c6c626",IIF(Fields!ID90.Value>="100" And Fields!ID90.Value<="200" ,"#c6c627",IIF(Fields!ID90.Value>="200","#9e2424","red")))