You will need to input the following formula in as a conditional
format.
Menu - Format - Conditional Format - [Change drop down to] Formula
is
=COUNTIF($B:$B,$B1)1
That should work...
JustMe.
--
JustMe602
------------------------------------------------------------------------
JustMe602's Profile:
http://www.excelforum.com/member.php...o&userid=27854
View this thread:
http://www.excelforum.com/showthread...hreadid=498031