Nov 12 2021 01:13 PM
I have a contact list with 700+ with columns for FirstName, LastName and Email. This is a growing list. I need to assure new entries are not repeats of previous entries. How can I highlight repeat inputs?
Nov 12 2021 01:29 PM
=COUNTIFS($A$2:$A$2600,$A2,$B$2:$B$2600,$B2,$C$2:$C$2600,$C2)>1
If you data is in range A2:C2600 you can enter above rule for conditional formatting in order to highlight double entries as shown in the attached file.