title: Highlight cells using VBA
body: <p>I want some cells to highlight when for example cell A1 is "test1".
  I tried to use conditional formatting but it only highlights that particular cell and nog a variety of other cells.
  I'm not a very experienced excel user but i think it is a simple VBA code to do this.</p>
  
  <p>I hope somebody can help me here.
  Tx</p>