title: Background color change in SSRS
body: <p>I'm trying to Highlight the row for 'Major group' and its 'subgroup' row in my report. where I have to change the background color of the row depending on the string value in the cell. </p>
  
  <p>Ex: if the column has a value 'MG' in it, the cell should show a 'SomeColor, say Green' background color. I tried the following:</p>
  
  <pre><code>=IIF(Fields!ProductGroup.Value = "MG", "Green", "No Color")
  </code></pre>
  
  <p>tried</p>
  
  <pre><code>=Switch(Fields!ProductGroup.Value = "MG", "DarkViolet", Fields!ProductGroup.Value="SG","Gold")
  </code></pre>
  
  <p>Nothing is working for me. What am I missing?</p>