Duplicate First and last name Question

[Lopez106]

Hi guys.
i was wondering how to highlight two columns if the first and last name match.

example in column E i have a last name and in column F i have a first name.
how do i make it highlight if i have a duplicate first and last name match?
thanks a bunch

 

[Joe4]

If you select the range E2 down to the last row with data in column F, and use this Conditional Formatting formula, it should do what you want:

=COUNTIFS($E:$E,$E2,$F:$F,$F2)>1

Here is my example:

 

[Lopez106]

If you select the range E2 down to the last row with data in column F, and use this Conditional Formatting formula, it should do what you want:

=COUNTIFS($E:$E,$E2,$F:$F,$F2)>1

Here is my example:
View attachment 116908

Thanks a bunch that did it.

 

[Joe4]

You are welcome. Glad I was able to help!