Highlighting duplicates between 2 ranges

Hi

I have numerical information in 2 lots of 3 columns eg a1:c10 and e1:g10 and I need to highlight if the information is in the same order in both ranges. example if A1=1 B1=7 C1=5 and e1=1 f1=7 g1=5 I would need that highlighting, it doesent matter if the rows are different ie A1=1 B1=7 c1=5 and e5=1 f5=7 g5=5 that would still be classed as a duplicate and need highlighting. Its the order of the information rather than the rows which is important to me. I used conditional formatting to find duplicates but can only get it to work on single columns can you please advise how I can extend that to a range.

Many thanks

Nigel

Pl see attached file.

One other thought ....
If A2:C2 contains your reference set of data to be compared with E2:G10 (say)
Select E2:G10, then apply CF using the formula: =SUMPRODUCT(($E2:$G2/$A$2:$C$2))=3
Format to suit > ok
-------------------------
Any good? Wave it, hit the little star at the bottom left of my response

Hi and sorry for the delay in responding to your kind advice, just to clarify I have attached a mock up of the type of thing I need. The information in range C3..E7 is compared with range G3..I7 In my example D4 does not match with H5 so both corresponding rows in the ranges are highlighted.

Managed to find this type of formula which when adjusted to cover the actual range addresses seems to work. Thanks anyway.

"=COUNTIFS($A$9:$A$13,A2,$B$9:$B$13, B2, $C$9:$C$13,C2)"