Highlighted unmatched data between two sheets and merge data in summary

Report
Posts
11
Registration date
Monday March 1, 2021
Status
Member
Last seen
August 11, 2021
-
Posts
11
Registration date
Monday March 1, 2021
Status
Member
Last seen
August 11, 2021
-
Hello,
I have two sheets contain data from COL A: COL G if there are new data in sheet1 but are not existed in sheet2 then should highlight by red color in sheet1 and if there are new data in sheet2 but are not existed in sheet1 then should highlight by red color in sheet1 and merge all of data in a new sheet " summary" with the same borders and formatting as in two sheets and with considering if I change any data in two sheets then should update in sheet " summary" and change the highlighted in two sheets
note: my data are about 2000 rows
sheet1


sheet2


summary




System Configuration: Windows / Chrome 90.0.4430.212

1 reply

Posts
11
Registration date
Monday March 1, 2021
Status
Member
Last seen
August 11, 2021

any help or not clear this subject?