Dear sir,
I have imported my users and orders list from old store to new store.
after complete importation, the user ids changed and because of that when i open existing orders, it says upgrade email warning as orders going to belong to another wrong user ( because of order owner identified by user id) and user id is not the same as my old store.
export users, email and id from old store data, add to columns A,B,C
exports users and email and id from new store data, add to columns D,E,F
then in colum G add =IF(AND(A2<>D2,B2<>E2,C2<>F2),TRUE,FALSE)
Drag the formula down to apply it to all rows in your data range.
Select the entire range of new formulas (e.g., column G).
Go to Home > Conditional Formatting > Highlight Cells Rules > Equal To.
In the dialog box, type TRUE and choose your desired formatting (e.g., red fill).
Click OK.
this will highlight all “mis matched” ones where you can edit