Use conditional formatting with a formula of

=COUNTIF($B2:$B$2000,$B2)1

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Leo Hamal" wrote in message
...
Hi all,

First of all all the best for 2008 and keep up the good work.

Example :
A B C ...
name1 10 5 ...
name2 1 10 ...
name2 15 2 ...
name3 1 10 ...

In an active sheet in Excell, I run a VBA sub to detect the doubles in col
A.
What I would like is that the 2nd. field with "name2" would change the
background colour.
For the moment I have added a dummy collumn where I put an eye catcher.
After that I sort the file and change the background collour manually.
The rest of the collums are not important for this event.

Any ideas?

Thanks,
Leo.