How to compare and highlight a column based other columns matching without replacement?

[chrismarince]

So I have a table...

A	B	C	D	E	F	G
54	8:45	Jane		Paul	8:45	37
37	1:12	Dave		Chris	5:35	78
78	5:35	Chris		Jane	6:40	90
90	6:40	Jane		Liz	2:05	14
37	8:45	Paul		Sarah	7:30	54
82	3:14	Matt		Jane	8:45	54
14	2:05	Liz		Dave	1:12	37
54	7:30	Sarah		Mike	9:00	14
14	9:00	Mike		Matt	3:14	82

<tbody>
</tbody>

Basically, what I need to happen is high light the values in Column A if they match those in Column G if the data in the corresponding columns (B and C) match those in F and E.

I understand this may not be entirely clear.

I need it to identify that for each row, columns A B and C match 1 row in columns E F and G.

For example, it would see that B1 = "8:45" and C1 = "Jane". Then it would look for a row where E= "Jane" and F = "8:45". These would be E6 and F6. Once these two rows are determined, it would see what the corresponding values from columns A and G are. So A1="54" and G6="54". Therefore, both 54's would be highlighted.

It should be noted that there are instances in which there could be multiple "Jane"'s or "8:45"'s or "54"'s in the columns. This is demonstrated in the table above. So the matching would need to be one-to-one or "without replacement". So once a row a cell or group of cells is used for a match, it is no longer used for future comparisons. This is incredibly important to the project because there will often be duplicates; some intentional and some by mistake.

If any of this is still unclear, please let me know. I find myself struggling with the appropriate wording of the problem.

If this can be done in conditional formatting as opposed to Macros, that would be ideal.

Thank you very much.