VB to find Find Duplicate

[rizmomin]

Hello:

Please refer to attached file.
Sheet "EmpInfo", Column G has lots of SS#, sample as shown.
I need a VB Code so that as soon as I come to EmpInfo Sheet, it will check for
duplicate SS# in Column G. If it finds dupliacte then it needs to highlight those with
RED

In this example it would need to highlight, Cell G2 and G3

Let me know if you have any questions.
Thanks.

[José Augusto]

Hi
Use conditional formating with the follwing formula

=COUNTIF(G2:G$20,G2)>1

Adjust range (g2:g20) to your data
See the file Duplicate.xlsx

[rizmomin]

Hello Jose':

Very good working solution.
Thanks a lot
Riz