Hi,

I have data in column A1:A500 eg S13245, S37583, S98402,S27640 ect.
Then in column S1:S500 I will either manually enter or paste similar
data from another work sheet. Now here's the rub. I would like to
attach a macro to a button to search both columns & where the data in
A1:A500 is the same in S1:S500, I would like the cell (s) in A1:A500
to turn Yellow.

The reason is that I can quickly see the non yellow data in A1:A500
and know I have missing matches, which will help me understand reject
activity.

Can anyone suggest a macro ?

Thanks in advance