title: How do I compare and highlight the matches from two columns in Excel without replacement?
body: <p>I have two columns of data in an Excel spreadsheet. I have to see that every value in Column A has a match in Column B. I understand that two columns can be compared and highlighted in Conditional Formatting using the Match function. </p>
  
  <p>The problem is that the the Match function in Conditional Formatting does not exclude previously matched and highlighted values from the list for future comparisons. For example...</p>
  
  <p>A: 1, 1, 2, 3</p>
  
  <p>B: 2, 3, 1, 0</p>
  
  <p>If using the Match function in Conditional Formatting, both "1" values in Column A would be highlighted because it sees that there is a "1" in column B. I need the columns to match one-to-one. So once a value is found to have a match in the other column, that match is excluded from the comparisons for the rest of the function's execution. If possible, I would prefer doing this entire project without the use of Macros. But if Macros are necessary, I am perfectly fine using them.</p>