Highlight duplicate cells where a cell in another column is also duplicate

Question

I want to achieve something like this:

Where I want to highlight cells on columns B-E when they're not unique but also are part of the same "category" (i.e. their row in column A is also the same). So for example, D8 doesn't get highlighted because there's no other 11 part of the Alpha category.

Maybe I'm searching for this wrong but haven't been able to found an example or something similar online. Thanks in advance!

Answer 1

try:

=INDEX(COUNTIF($A$2:$A&$B$2:$E, $A2&B2)>1)*($A2<>"")