title: How to Add Excel-like "color scale" red-yellow-green conditional formatting in SSRS report based on min and max values
body: <p>How can I create heat map in SSRS based on min and max values?
  Right now I'm using SWITCH function in order to differentiate colors. </p>
  
  <pre><code>    =
      SWITCH 
          (Fields!.Value = 0, "Coral",
              Fields!.Value &gt;=1  and Fields!.Value &lt;= 5 , "Yellow", 
              Fields!.Value &gt;=6  and Fields!.Value &lt;= 10 , "Gold", 
              Fields!.Value &gt;= 11 and Fields!.Value &lt;= 16,"#bdff30",
               Fields!.Value &gt;= 17 and Fields!.Value &lt;= 22,"#7fda24",
  Fields!.Value &gt;= 55 ,"#0ca102")
  </code></pre>
  
  <p>But how can I just tell SSRS that, for example between 5 different values, choose heat map colors, lets say shades from red to green and assign those colors to each value in a cell?
  Should be like this:
  <a href="https://i.stack.imgur.com/lpY60.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lpY60.png" alt="enter image description here"></a></p>