For every duplicate entry in column D, highlight row if G column value is separate

For every duplicate entry in column D, check the G column of that row.

If the G column's value for that entry is different than the other duplicates, highlight it red.

Example:

If "Dog" is repeated 8 times in the D column.

For each time "Dog" appears in the D column, check that row's G column.

If the value in the G column for that row is not repeated in any other "Dog" columns, then highlight it red.


It should do this for all duplicate names though, not just "dog".