Excel Excel Formulas Recognize duplicate entries. Select entire column, right click conditional formatting -> custom formulae (https://www.youtube.com/watch?v=CrwFQqxzQn8) =COUNTIF(D:D, D2)>1priyankmaniarFebruary 27, 2020