title: Google Sheets Conditional Formatting range compared to cell
body: <p>Attempting to compare cells in range G3:AM46 to their row's corresponding E cell, and when the number in the range cells is less than or equal to the E cell it should highlight it. None of these fields have any formulas or conditional formatting other than this, they are all basic numerical values.</p>
  
  <p>The goal in plainer English is for me to be able to put in the number of each item that I have in col E, and in G-AM put how many I need to be able to build the structure it's the column for. I want it to highlight the ones that I have enough of that item to build that part of the structure.</p>
  
  <p>Attempts that have failed:</p>
  
  <ul>
  <li>Range: G3:AM3 (or G3:AM46), Format Cells if: "less than or equal to" $E3
  
  <ul>
  <li>Result: All highlighted regardless of higher or lower</li>
  </ul></li>
  <li>Range: G3:AM3 (or G3:AM46), Format cells if: "greater than or equal to" $E3
  
  <ul>
  <li>Result: No cells highlighted regardless of higher or lower</li>
  </ul></li>
  <li>Range: G3:AM46, Format cells if: "Custom Formula" =$G3:$AM46>$E3:$E46 or =$G3:$AM46=$E3:$E46 or =$G3:$AM46&lt;=$E3:$E46
  
  <ul>
  <li>Result: Same as above two (depending on greater/less than)</li>
  </ul></li>
  </ul>
  
  <p>I've also tried a wide variety of combinations related to the $ but I may have missed some. I've also tried just doing it by column (compare G to E without ranges) and I can't get that to work. I tried a single cell and that didn't work either.</p>
  
  <p>Spreadsheet is located here: <a href="https://docs.google.com/spreadsheets/d/1NI-eDdxBMKQzNR-LdRKX2zJ-d1uUllImPTzeOdQI8lI/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1NI-eDdxBMKQzNR-LdRKX2zJ-d1uUllImPTzeOdQI8lI/edit?usp=sharing</a></p>