vba compare between two sheets and highlight new items

could be help guys?

no answering so far !
posted here
https://www.mrexcel.com/board/thread...items.1231959/

Give this code a try:

Please Login or Register  to view this content.

Thanks !
may you check file ,please?
after I run the macro there is problem in column D for row14 doesn't show wrong mark and values in column E and highlight the row .
and row 16,17 there is no wrong mark . as to first sheet should also highlight new items as I did it in OP .

thanks again !
in column D for red ranges should show minus values when subtract column C for sheet2 from column C for sheet1 , then will show minus values , not zero as the code does it and should show wrong mark in column D , not right mark as the code does it , you can compare with expected result for columns I:M
I attached file after testing to see the errors.

I see the errors in the file you provide but can't recreate those results when I run the code. Please let me know if the issue persists.

I see the errors in the file you provide but can't recreate those results when I run the code. Please let me know if the issue persists.

do you mean the errors doesn't show for you?!
actually the errors are still showing .

ok this is because of running the macro repeatedly . data could change or update in two sheets , so how fix it ,please?

The updated code actually deletes the rows in red on sheet2 and recreates those lines just in case those have changed. You do not have to manually delete those lines. The green lines are also updated if column c is changed. Try both those cases and let me know if there are any discrepancies.

what happened for me something is strange !( it will not highlight new items by green despite of there are existed in sheet2 but it's not existed in sheet1 for items 13,16) .

Line items on sheet2 will only change green if columns D and E are empty in a row when the code runs. The code is looking for any bypassed items(no match with sheet1) and then highlights them green. If there is data in the last two columns of that row the code assumes it was populated because that item existed on sheet1. Does that better explain the process for you?

Line items on sheet2 will only change green if columns D and E are empty in a row when the code runs. The code is looking for any bypassed items(no match with sheet1) and then highlights them green. If there is data in the last two columns of that row the code assumes it was populated because that item existed on sheet1. Does that better explain the process for you?

I'm really sorry !
I lost my concentration because of posting many answering .
I appreciate for your effort & time.
many thanks