You can use Conditional Formatting to find duplicates which is what it
seems like you want to do. In B2 go to the Format menu, select
Conditional Formatting. Change the Cell Value is option to Formula is
and type in,

=COUNTIF($B$2:$B$36000,B2)1

Click on Format, Font, change the font color to whatever you want.
Click OK and OK.

You can then use the format painter to apply this to the rest of your
list.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=522793