Select row 1 (or just part of row 1). Format-Conditional Format.
Formula is:
=ISNUMBER(MATCH($A1,'Sheet2'!$A:$A,0))

Copy formatting across/down as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Vic" wrote:

I hate to post similar question, but...
How can I highlight the entire row in Sheet1 when A1 matches A:A of Sheet2?
Thank you.