Macro to highlight duplicate fields [in Blue]

Good day all,
I would like to know how I can have a macro run on an excel sheet of mine.

I have a little database with a few names and email addresses submitted to me via web.

But some people tried to register to my services TWICE with a different name, but same email address (not smart eh)

I would like to run a macro on a column and have it search for duplicate values and highlight them in... blue perhaps.?

P.s. the column format is set to 'TEXT'

Your help is much appreciated.

You'll find 3 methods here.

http://www.brighthub.com/computing/w...les/42515.aspx

Hi.

Post a sample data file.

Originally Posted by mahaveersomani

check thea attached file i think this will be useful to you....

conditional formatting is used by me....

if this was helpful to you then dont forget to hit * button for user reputation...

Regards
CA Mahaveer Somani

Thats a good sample Mahaveer,

but how Id prefer to highlight the cell (background color) so it can stand out more to me. because some time the "TEXT" field see's an email as a hyperlink and turns it into a clickable link. (which I hate having to remove all hyperlinks)

Originally Posted by mahaveersomani

check thea attached file i think this will be useful to you....

conditional formatting is used by me....

if this was helpful to you then dont forget to hit * button for user reputation...

Regards
CA Mahaveer Somani

Thats a good sample Mahaveer,

but how Id prefer to highlight the cell (background color) so it can stand out more to me. because some time the "TEXT" field see's an email as a hyperlink and turns it into a clickable link. (which I hate having to remove all hyperlinks)