Excel 2000

How do I:

1. load a list of data into an array;
2. check whether cells in another list are contained in
that array (highlighting cells which are not)

Thanks.