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 specialformat 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.

--
Can''''t hear the Rain ?
Then listen to it.


"mrcheatherington" wrote:

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