I have a spreadsheet that is continuosly fed names there are over 500 names that I have to update. Some are new and some are duplicates is there a way to know if a name that was submitted or added is a duplicate. Kind of like a rule where it is equal to changes it to yellow? As you can tell I am not excel smart at all. So please speak slowly