Find Duplicates
Using Conditional Formatting
If Range is A:A, select that range, open Conditional Formatting and select "Formula Is", then enter
=COUNTIF(A:A,A1)>1
Choose whatever format to show duplicate entries (A1) you prefer
© Copyright
andrewsexceltips.net
. All Rights Reserved.