Quote Originally Posted by JBeaucaire View Post
Change your Conditional Formatting formula for B6 to:

=ISNUMBER(MATCH(B6,$A:$A, 0))

Then copy that format to B6:M150 using the Format Painter.
Just in case he wants to apply conditional formatting to unused ranges for future use, you may need to provide for blank cells as well as I did on my example.