You could use conditional formatting. In A1 use the Formula is option
in conditional formatting. Use this formula.

=COUNTIF($B$1:$B$9,A1)=0

Click on Format, Patterns, and select a color to fill in the cell to
identify it as not being found. Click OK, OK. Use the format painter
to apply to the rest of your cells in A.

HTH

Steve


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