title: SSRS SWITCH colours based on two columns
body: <p>I have a dataset with several depots and stock columns based on each depot.</p>
  
  <pre><code>=SWITCH(Fields!ID2_0m_Avlalon_Gate_Barrier.Value &lt;=100 , "Red", Fields!ID2_0m_Avlalon_Gate_Barrier.Value &gt;100, "Green")
  </code></pre>
  
  <p>The above code works fine.</p>
  
  <p>I am trying to set a back fill property for each stock column to change based on the depot selected AND the amount of items in stock.</p>
  
  <p>So far I have made a basic switch work for the column but cannot figure how to then add the depot equation into it:</p>
  
  <pre><code>=SWITCH(Fields!ID2_0m_Avlalon_Gate_Barrier.Value &lt;=10 AND Fields!Depot_Location.Value = 'Carlisle', "Green",
  Fields!ID2_0m_Avlalon_Gate_Barrier.Value &gt;10 AND Fields!Depot_Location.Value = 'Carlisle', "Red"
  )
  </code></pre>
  
  <p>I get the following error: </p>
  
  <blockquote>
    <p>The BackgroundColor expression for the text box ‘ID2_0m_Avlalon_Gate_Barrier’ contains an error: [BC30201] Expression expected. </p>
  </blockquote>
  
  <p>Any help would be appreciated.</p>