How to match two character in excel (like order no & Products are repeated . how to pickup the value column 2 to 1?

In Excel Select Both Columns And Then 1. Click On Conditional Formating

2.Select Highlight Cell Rules

And Select Duplicate Values

as Atif mentioned, question isn't clear. if we have to pick up products from column2 based on the order number in column1, we can use VLOOKUP. or if you are looking for something else, please let me know

question is not clear, will you please give more detail