title: SSRS change fill color based on column values and parameters
body: <p>I want to change the background fill color of a column based on what parameters the user selects, and the values resulting from the filter are either red, green, or yellow. </p>
  
  <p>If Parameter1 = "A" and Parameter2 = "B", then results are filled based on requirements (below). If Parameter1 = "C" and Parameter2 = "D", then numbers are filled based on other requirements. If Parameter1 and Parameter2 are any other value (E, F, G), then leave the background "White".</p>
  
  <p>What I tried so far:</p>
  
  <p><code>=Switch(Parameters!Site.Value="A" AND Parameters!Place.Value = "B", IIF(Fields!Cost.Value &lt; 100, "Green", IIF(Fields!Cost.Value &gt;= 101 AND Fields!Cost.Value &lt;= 200, "Yellow", IIF(Fields!Cost.Value &gt; 300, "Red", "White"))), "White")
  OR
  (Parameters!Site.Value="C" AND Parameters!Place.Value = "D", IIF(Fields!Cost.Value &lt; 300, "Green", IIF(Fields!Cost.Value &gt;= 301 AND Fields!Cost.Value &lt;= 400, "Yellow", IIF(Fields!Cost.Value &gt; 400, "Red", "White"))), "White"), True, "White")</code></p>