title: Copying conditional formatting in google sheets
body: <p>In google sheets is there a way to copy just the conditional format without copying the cell that is being validated?  Meaning</p>
  
  <p>I have a value in E2:E37</p>
  
  <p>I want to create a conditional format rule
  IF E2 &lt; D2 Fill Color Green
  IF E2 > D2 Fill Color Red</p>
  
  <p>Instead of creating this rule on each cell in E3-E37 I want to copy the rule, however, when I do copy -> paste special -> conditional formatting only It will copy the rule but validate against the cell in which its being copied from.</p>
  
  <p>Apply to range will change from E2:E3
  Formula will remain at =D2</p>