Hello , I have 2 sheets contain different information. Sheet 1 has 400 lines with invoices number / total amount/ date and etc.. . Sheet 2 also has invoice invoice number and total amount but in difference order with Sheet 1. I am trying to make a formula that check both sheets if they have the same invoice number and total, then highlight that invoice number in sheet 1. For example, sheet 1 B1 is invoice number 166266 and c1 is total amount 500, if there is Sheet 2 has the similar invoice number and total amount with Sheet 1 then highlight B1 . Is that possible ?
Solved by G. U. in 18 mins