Need Macro which identifies duplicates in a column and colors the duplicate values

Hi All,

I need a macro which should identify the duplicate values in a column in excel and either return a message box with total number of duplicates or color the duplicate values in that particular column.

I have attached the sample worksheet.

If you just want to colour the cells then you don't need a macro, you can use conditional formatting with a formula of:

=COUNTIF(A:A,A1)>1

Originally Posted by Andrew-R

If you just want to colour the cells then you don't need a macro, you can use conditional formatting with a formula of:

=COUNTIF(A:A,A1)>1

Thanks for the Clarification, however is it possible to include that formula in a VBA code ?