title: How do I resolve a Conditional format comparing two ranges?
body: <p>I have a column of cells with a value
  I have another column of cells with a value</p>
  <p>Let's say G5:G15 and D20:G30</p>
  <p>I need to compare each with a greater than or equals and less than</p>
  <p>Can I run this through a ranged conditional format?</p>
  <p>I.E.</p>
  <blockquote>
  <p>Range: G5:G15</p>
  <p>Custom Formula: =G5&gt;=D20</p>
  <p>Format: Green Background</p>
  </blockquote>
  <p>I've tried the above, but it didn't work.</p>