How do I find duplicates rows and columns?

I can find duplicates in a single column but I need to identify duplicates if everything matches except one column. So A:H matches but not I. Basically the same as removing duplicates and how you can select the columns, but instead of removing, I need to highlight.

Thanks dflak, i'm not sure how that will accomplish what I need though. I've attached a workbook with what I want vs what I have.

The rows have to be highlighted so I can identify the duplicates.

Try

in I2

=IF(COUNTIFS(A:A,A2,B:B,B2,C:C,C2,D:D,D2,E:E,E2,F:F,F2,G:G,G2)>1,1,0)

copy down

use CF to highlight all cells where column I is 1

Thank you!