Thanks! Worked like a charm!!
I appreciate your help!
Melissa

"JustMe602" wrote:


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