Try using Conditional Formatting with =countif(range,cell)>1