Identifying duplicate values in a range based on another criteria of duplicates

[FMulho]

I am trying to find a formula that allows me to do the following in order:
1) If the group ID is the same AND (2) if the Part # is the same as the (3) Part # with the minimum group price, highlight this.

For example below, I want to highlight part # MPN1 because it is has the same GroupID and Part # as the Part with lowest group price for group ABC:

[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]GROUPID[/TD]
[TD]PART #[/TD]
[TD]PRICE[/TD]
[TD]MIN GROUP PRICE[/TD]
[/TR]
[TR]
[TD]ABC
[/TD]
[TD]MPN1[/TD]
[TD]1.00[/TD]
[TD]0.50[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]MPN1[/TD]
[TD]0.50[/TD]
[TD]0.50[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]MPN4[/TD]
[TD]1.00[/TD]
[TD]0.50[/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]MPN3[/TD]
[TD]2.00[/TD]
[TD]1.50[/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]MPN3[/TD]
[TD]2.50[/TD]
[TD]1.50[/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]MPN5[/TD]
[TD]1.50[/TD]
[TD]1.50[/TD]
[/TR]
</tbody>[/TABLE]

Any help is much appreciated!

 

[Eric W]

Select columns A:C, click Conditional Formatting > New Rule > Use a formula > and enter:

=AND($B1=INDEX($B:$B,MATCH(MIN(IF($A$1:$A$100=$A1,$C$1:$C$100)),IF($A$1:$A$100=$A1,$C$1:$C$100),0)),$A1<>"")

and select your fill color. If you have column D, you can shorten the formula to:

=AND($B1=INDEX($B:$B,MATCH($D1,IF($A$1:$A$100=$A1,$C$1:$C$100),0)),$A1<>"")