Highlight duplicate rows by grouping?

In Numbers is there any way to highlight duplicate rows that occur in a grouping.

By grouping, I don’t mean any of the built in tools for creating categories. Instead, I am referring to a column I am using for grouping data.

Example:

In the example, column B "Type" is used to group the data.

The Fruit data has the duplicate entry "Apple".

However, the "Apple" entry under "tech" wouldn't count as a duplicate, because it's part of a different group.

Is there anyway I can highlight the duplicates (in this case rows 2 & 5, and 9 & 11).

Also, can I filter it so, I only see each duplicate per a category to make them easier to delete?

Thanks!