Cross reference using "isnumber" & "match"

I came across a post earlier today in the forum that used a formula which I changed as follows to suit my current needs:

Please Login or Register  to view this content.

Two questions:

#1. I will be adding more data to Sheet2. Is there a more proper way to write the formula so it looks at the entire column A as the array so I do not have to rewriting the array?

#2. Since the formula returns a TRUE/FALSE can i incorporate a conditional formatting in the formula so that if TRUE is returned then the row of data turn yellow and if false it remains as is or does that have to be done as a separate function through Conditional formatting?

Teylen,

Thanks for the quick response.

After seeing your post i notice I left one thing off. The formula i provided executes in column M so what it really looks like now is:

Please Login or Register  to view this content.

I believe the array of R1C1:R6053C1 covers point #1. (Sorry, I am getting into the habit of figuring out my problems while i write up the posts).

Now point #2 is not so easy for me because I have not really attempted any conditional formatting within a macro.

How would I code "if M2 = TRUE then make Row 2 BOLD, if not leave it as it is.

This leads me to a 3rd question of do I really need to have the code in point #1 return a value in M or can it just "run" through the provided array and if it finds a match between Sheet1 and Sheet2 it bolds that row??

Sorry if I am losing you on this one.