title: Excel Highlight one row based on another
body: <p>I am trying to compare one row with another: IF the cells in Row 1 is equal to Row 2, THEN I must have  highlighting. I've tried 100 methods for over an hour now. The problem is that Excel keeps the formula the same across the row!! the formula needs to change, meaning: I am NOT trying to highlight the whole row based on just the first cell, the cell needs to dynamically change. First cell to first cell, 2nd to 2nd, etc. <a href="https://i.stack.imgur.com/Dnz5C.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Dnz5C.jpg" alt="enter image description here"></a></p>
  
  <p>The circled words need to be highlighted. </p>
  
  <hr>
  
  <p>Sorry to ensure everyone is clear on the requirement, here is my requirement: 
  <a href="https://i.stack.imgur.com/ClZPL.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ClZPL.jpg" alt="enter image description here"></a>
  The solution, as a brilliant guy below mentioned, was a stupid $ sign. </p>