Hello,

I have been looking around for an answer to this, and have no come across anything that may assist with my current situation.
I have 2 Sheets in Excel, one is already filled out with Data such as

Name Number
Ben 1
Steve 1
Ben 2
Chad 3

I am looking for Conditional formatting so that if in the second sheet someone enters something that matches both criteria, it becomes highlighted.
So if someone were to enter

Ben 1

This would cause it to highlight as that exact match of name and number exists on the other sheet, whereas something like

Ben 3

This would not cause it to highlight.

More or less looking to highlight anything that is a duplicate of the previous sheet.

Conditional Formatting is definitely not my strong suit, so any help would be appreciated.