title: using excel to show Increase, Decrease and no change in Multiple colours
body: <p>Looking for some help or to be pointed in the right direction. Been stuck on this for a while and the main issue is I don't even know where to start. I am sure there is a solution but my brain will not see it. </p>
  
  <p>To use as an example I have a table that shows monthly results for multiple different areas:</p>
  
  <p><a href="https://i.stack.imgur.com/z4JTn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/z4JTn.png" alt="enter image description here"></a></p>
  
  <p>What I want to do is in the gap along side each number is show an increase, decrease or no change, using up arrow down arrow and square. That I can do using conditional formatting my issue comes with the fact that I also want it to be multiple Colours. So it will take into account increase and decrease and whether they are in target.See below:<a href="https://i.stack.imgur.com/LVDTf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LVDTf.png" alt="enter image description here"></a></p>
  
  <p>Atm I am copying and pasting each month. But having it automated would be amazing. The outcome would hopefully look like this:<a href="https://i.stack.imgur.com/6kfCV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6kfCV.png" alt="enter image description here"></a></p>
  
  <p>I am hoping there is a way that I can do two things compare to the previous month and then check it against my table to see where it sits then display the appropriate symbol.</p>
  
  <p>Thank you in advance for any help or a place to start.</p>