title: Trigger a macro based on a certain value in a cell
body: <p>I have a macro that triggered by a button and then colours a certrain range. So like:</p>
  
  <pre><code>Sub colourRange()
     #Colour range
  end sub
  </code></pre>
  
  <p>This all works but thing is that i have to push a button for it to work. What I am actually looking is some kind of if / else statement that triggers a macro when you fill in a certain value in a cell.</p>
  
  <p>Can anbybody tell me if there is a way to trigger a macro by typing a certain value in a cell?</p>