Index Match or Vlookup with Color Highlight

[Mstg007]

I know this has been ask ALOT over here. I cant seem to find what I looking for to hopefully get this to work.

In my first tab I have a list of all sorts of number in column A3 down to A1786. in my second tab I have a couple hundred numbers from A1 to A600.

How can a color highlighted cell green if the number is on the second tab? and to make it more interesting... How can I get the highlighted cell to also select the 11 cells right of the lookup cell?

Thanks for any help!!!

 

[wideboydixon]

Highlight A3:L1786 on the first sheet and add a conditional format based on this formula:

=ISNUMBER(MATCH($A3,Sheet2!$A$1:$A$600,0))

Change "Sheet2" to be the name of the second tab as necessary.

WBD

 

[Mstg007]

Thank you so much! It worked!