Conditional formatting to highlight duplicates based on multiple criteria

[jimbokeep]

I am trying to create a formula within conditional formatting, which will highlight data that is duplicated within a separate report.

I've attached a file to help explain what I am trying to achieve.

Columns A to C represent a database from which I am looking up data to complete a report. The report is represented in columns F to H.

The report lists part codes in column A and an order number in cell H2.
In column G, there is a SUMPRODUCT formula used, to look up the Order number in column B, and part code in column A, and return the Unit price from column C.

I'd like to use conditional formatting to highlight in column F, when a part code appears multiple times in a specific order in the database data, columns A to C.

If anyone could help me with this, it would be greatly appreciated.

[davsth]

You have virtually done it yourself lose column c from your formula it will count instances if >1 then duplicate

=SUMPRODUCT(($H$2=$B$3:$B$15)*($F4=$A$3:$A$15),$C$3:$C$15) add >1 delete this and use as formula for conditional format

=SUMPRODUCT(($H$2=$B$3:$B$15)*($F4=$A$3:$A$15)) >1

a countifs would do the same thing as well

[jimbokeep]

Thanks very much for this. It's really appreciated.

So often the case I end up overthinking these things, when the answer is staring me in the face.