asked on

Excel 2007 Comparion Assist

Hello,

Need assistance on a comparison report. Please see attached. I need a formula or VB that will look at the two tabs and if there is a matching E Code, confirm that E Code has a last name in the Master tab. If there is no match, highlight the row to column F green on the master tab.

For example, on the sample provided, row 4 has a matching E code on the Data tab but there is no last name. Therefore, that row would be highlighted green. Rows 2 and 3 have matching E Codes but there are last names so those would not be highlighted. Row 5 has a name but the E Code does not match the E code on the data tab so that would not be highlighted.

Thanks!
EE-Sample.xlsx

ASKER CERTIFIED SOLUTION

barry houdini

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Escanaba

ASKER

So simple a caveman could do it. :-)
Thank, Barry! Exactly what I was hoping to see.

Saqib Husain

Was that a compliment?

:-=

Escanaba

ASKER

Actually yes it was indicating that it was a simple and effective solution to the problem being presented followed up by the THANKS.

Escanaba

ASKER

Of course, in this day and age to be completely politically correct if you are, indeed, a caveman ssaqibh, then I apologize for my prejudice remark. Can only imagine what you poor people have been through with all of the insurance commercials these days. :-)

Saqib Husain

Yeah! what worried me was that you were comparing our dear and respected genius Barry with us poor cavemen. Barry, Just ignore that comment, he did not mean it.