title: SSRS Change Fill Colour Depending on Cell Values
body: <p>I'm aware this has been asked a few times however I'm struggling to find an answer to what I need it for (Or maybe I have missed the answer so please feel free to copy and paste a link if has already been asked)</p>
  
  <p>I'm aware through searching on here the <code>Switch</code> function can help change the colour of the background depending on the value.  I have 3 colours needed, however one seems to over ride the other which is causing the issue, and I think this is because one value is in between two numbers</p>
  
  <p>I'm trying to show </p>
  
  <p>Equal or greater than 10 - Red
  Equal to or greater than 5 until 9.99 - Amber
  Equal or greater than 0 until 4.99 Green
  Less than 0 until -4.99 Green
  -5 until -9.99 Amber
  -10 or greater Red</p>
  
  <p>I'm using this but it isn't working;</p>
  
  <pre><code>=switch(Fields!Field_Name &lt;= -10, "Red",  
  Fields!Field_Name &lt;= -5, "Amber",
  Fields!Field_Name &gt;= 10, "Red", 
  Fields!Field_Name &gt;= 0, "Green", 
  Fields!Field_Name &lt;= 4.99, "Green",
  Fields!Field_Name &lt; -0.1, "Green",
  Fields!Field_Name &lt;= -4.99, "Green",
  Fields!Field_Name &gt; 5, "Amber", True, "Green")
  </code></pre>
  
  <p>Any help (and not ridicule) would be really appreciated!</p>
  
  <p>Cheers</p>