Consider the data in the following table. There are duplicate invoice numbers with the same amount. So, to find the duplicate from multiple columns, we need to combine these two columns first. For this helper column, we need to apply Conditional Formatting. So, select the helper column and choose Duplicate Values under the Conditional Formatting option. It will highlight the duplicate values.