Designing a function/macro that compares 2 columns and highlights rows that are missing

Hi Everyone,

Here's my situation, I'll try to be as clear as possible. I have two tables of data in my workbook on separate sheets. The first sheet, "Accounts Master" is a master list that is updated monthly. The second sheet "Current Accounts" contains the same info (in a different order), but it is added to as accounts are added into the system. Both lists will be expanding in quantity as the months go by, in case that's relevant.

Here are the two sheets side by side for reference.

Excel Help.jpg

Ideally, what I'd like to do is have the master list "consult" the current list and see if there are any accounts on the master list that are not on the current list. If the account is missing, I would like to highlight that row in a yellow color on the master list.

Incase it's not clear from the picture, the account #'s begin at E11 on the "Current Accounts" sheet and on the "Accounts Master" sheet the #'s begin at B10

I have tried to adapt some similar macros from the board to fits my needs but I have been having a lot of trouble because I am very inexperienced with macros.

I would really appreciate any help you guys could offer. It would make my job 1000x easier!

Thank you