title: Conditional Formatting based on relative column
body: <p>I have a sheet in which I created a conditional formatting rule:  </p>
  
  <blockquote>
    <p>if columnB > 50 then columnA fill color green.</p>
  </blockquote>
  
  <p>The result is OK for the whole of columnA, based on columnB. The problem is that when I copy the format to columnX this should be based on columnY but remains based on columnB.</p>
  
  <p>I need an automatic way to format the cells based on the neighbouring column and not a fixed column.</p>