Highlight 2nd or more Duplicates Conditional Format

[mirology]

I use the Following Conditional Formula to highlight rows if multiple cells together are duplicated:

=SUMPRODUCT((col_b=$B1)*(col_C=$C1)*(col_d=$d1)*(col_e=$e1))>=2

and it works fine except it highlights all instances not only 2nd or 3rd or more duplicates as intended


I've tried countifs formula but it highlights wrong rows and doesn't highlight the 2nd or more instances

not sure what im missing here

 

[StephenCrump]

Perhaps: =MATCH($B1&$C1&$D1&$E1,col_b & col_c & col_d & col_e,) < ROW()-ROW(A$1)+1 <row()-row(a$1)+1<row()-row(a$1)+1< html=""></row()-row(a$1)+1<row()-row(a$1)+1<>