Solved: Column Values Duplicate

[joms]

Hi guys, this might be a common problem...but how to detect duplicate values in a single column and change the color of the duplicata data, to indicate that it's a duplicated value?

thanks... :)

[Bob Phillips]

Use conditional formatting with a formula of

=COUNTIF($A$1:A1,A1)>1

[joms]

hi xld, thanks...how to use countif formula to a macro statement?

;)

[Bob Phillips]

Why VBA, Conditional formatting does it all.

[joms]

thanks xld, why i want vba because i want to put a color on the cell which is duplicated... anyway thank you so much for your help... :)

[Bob Phillips]

That is what CF does in the manner I showed you.

[mdmackillop]

If you want all duplicates marked including the original instance, use CF with
=COUNTIF($A:$A,A1)>1