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.
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.
Attempts that have failed:
- Range: G3:AM3 (or G3:AM46), Format Cells if: "less than or equal to" $E3
- Result: All highlighted regardless of higher or lower
- Range: G3:AM3 (or G3:AM46), Format cells if: "greater than or equal to" $E3
- Result: No cells highlighted regardless of higher or lower
- Range: G3:AM46, Format cells if: "Custom Formula" =$G3:$AM46>$E3:$E46 or =$G3:$AM46=$E3:$E46 or =$G3:$AM46<=$E3:$E46
- Result: Same as above two (depending on greater/less than)
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.
Spreadsheet is located here: https://docs.google.com/spreadsheets/d/1NI-eDdxBMKQzNR-LdRKX2zJ-d1uUllImPTzeOdQI8lI/edit?usp=sharing
