title: Excel conditional formatting per row cells
body: <p>Is it possible to create a conditional statement to do the following without having to create the conditional format for each row?</p>
  
  <p>For each row, if row column D cell is less than the value of row column A cell I want it to highlight red. If row column D cell is greater than the value of row column A cell, I want it to highlight green.</p>
  
  <p>Example: </p>
  
  <pre><code>if D1 &lt; A1 Highlight RED
  if D1 &gt; A1 Highlight GREEN
  if D2 &lt; A2 Highlight RED
  if D2 &gt; A2 Highlight Green
  </code></pre>
  
  <p>and so on and so forth....</p>
  
  <p><a href="https://i.stack.imgur.com/faW3w.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/faW3w.png" alt="enter image description here"></a></p>