How to find blank rows of data - macro

[missy22]

I am writing to request a macro which can find missing rows of data from column E and F using the condition below:

Macro condition:

If a name (column D) has no ids in either columns (E or F) in one row and the same name, in another row has either one id or both, then highlight this variance.

Please see the attachment below, for further reference (Please use the sample4 file, which is updated, as I am little unsure how to delete other files. So please ignore the other attachments (samepl3). Thanks.
sample4.xlsm

The attachment shows sample dataset with desired output highlighted.

Thank you for your time and help.

[venkat1926]

D15 and D21 are not same . corrected by just copy pasting.

what about D18. is it because it is only one row you did not color it

you blanks are NOT ACTUAL BLANKS. WHAT DID YOU DO
CHECK"
in an empty cell type
=isblanks(E2)
you get FALSE
This gave me lots of probloem
WHY?????????
I have corrected it with a macro -see vbeditor

your sheet exacly your coloring is copied in second sheet "original missy sheet"
sheet 1 is now the source data(activesheet) on which macros work. the macro removes original coloring and codes work.

a main macro "test" gives what you want--not exactly.
why did you not color rows 6 and 7
and rows 19 and 20. either your conditions are not cler to me or there is some error you
in your manual coloring.

I am attaching the file


IT IS ENOUGH IF YOU RUN "FINALMACRO"
you are at liberty to modify tHe macros

you cab tweak the codes by removing lines not required.

ATTACHING THE FILE