Please see attached file. I need a method of comparing the two worksheet tabs based on the following criteria:
If the data tab has an E Code that matches an E Code on the Master tab but there is no last name, highlight that row in columns A & B only in red.
Therefore, based on the attached example, row 4 has a matching E code on both tabs but there is no last name, so that row should be highlighted red. Rows 2 and 3 have matching E Codes but there are also names associated with those codes so no action required. Row 5 is missing a last name but the E Code does not match up between the two tabs, so no action required.
I am assuming someone can put this into a more compact formula with conditional formatting then the long-winded alternative I'm coming up with so any assistance would be greatly appreciated.