|You could use Conditional Formatting with this Formula:|
For Excel 2003:
Select all of the values in Column A and Choose Format...Conditional Format...Formula Is
Pick a pattern color.
If the value in A is also in B, the cell will turn that color.