title: SSRS Color code based on comparison between two columns in a matrix
body: <p>I have build a matrix in my report that brings data for every month. I need to check if the data for current month is greater or lesser than the previous month. If the data is greater than the previous month, then the foreground colour will be turned as "Green" else "Red"</p>
  
  <p>To put things into perspective, example is attached herewith.</p>
  
  <p>SSRS Report:  <a href="https://i.stack.imgur.com/TGET8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TGET8.png" alt="enter image description here"></a></p>
  
  <p>Preview of the report:</p>
  
  <p><a href="https://i.stack.imgur.com/oju26.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oju26.png" alt="enter image description here"></a></p>
  
  <p>As you can see the preview of the report,for first row, Sep 2019 revenue and Oct 2019 revenue are 574,100 and 217,900 respectively. Hence the october 2019 value will be in RED as revenue has fallen down as compare to Sep 2019. Similarly, the logic is same for "Gross Margin" column</p>
  
  <p>How do I enter the color value for each month and subsequently for quarter values also (as quarter values will also be compared)?</p>
  
  <p><strong>Question EDIT</strong> <a href="https://i.stack.imgur.com/DlkRG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DlkRG.png" alt="enter image description here"></a></p>