'Flag duplicate relationship in excel

I have data available in excel as given below:

Below is the criteria for the expected column:

Duplicate relationship should be color coded/flagged.

I have added expected result in a column G Is duplicated?.

To achieve that I have tried using Match function of excel, but it doesn't match my requirement.

Please suggest what should be the correct approach to fix this.

excel excel-formula

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source