how do i sort a worksheet data to show repetitve data and show

M

mrcheatherington

can anyone tell me how to sort data to show repetitve data and highlight it
in the array?
 
T

The Rain

Using conditional formatting CF.
Select A1 > format > conditional formatting, dropdown to "formula is"and
write :
=COUNTIF(A:A,A1)>1
FORMAT and CHOOSE color > ok.
Copy-paste special>format in all cells you'd like this condition to apply.
Remember, as you did not give me range I used A column, but adjust as needed.
 
Top