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

[chrismarince]

So I have a table...

[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]54
[/TD]
[TD]8:45
[/TD]
[TD]Jane
[/TD]
[TD][/TD]
[TD]Paul
[/TD]
[TD]8:45
[/TD]
[TD]37
[/TD]
[/TR]
[TR]
[TD]37
[/TD]
[TD]1:12
[/TD]
[TD]Dave
[/TD]
[TD][/TD]
[TD]Chris
[/TD]
[TD]5:35
[/TD]
[TD]78
[/TD]
[/TR]
[TR]
[TD]78
[/TD]
[TD]5:35
[/TD]
[TD]Chris
[/TD]
[TD][/TD]
[TD]Jane
[/TD]
[TD]6:40
[/TD]
[TD]90
[/TD]
[/TR]
[TR]
[TD]90
[/TD]
[TD]6:40
[/TD]
[TD]Jane
[/TD]
[TD][/TD]
[TD]Liz
[/TD]
[TD]2:05
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]37
[/TD]
[TD]8:45
[/TD]
[TD]Paul
[/TD]
[TD][/TD]
[TD]Sarah
[/TD]
[TD]7:30
[/TD]
[TD]54
[/TD]
[/TR]
[TR]
[TD]82
[/TD]
[TD]3:14
[/TD]
[TD]Matt
[/TD]
[TD][/TD]
[TD]Jane
[/TD]
[TD]8:45
[/TD]
[TD]54
[/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD]2:05
[/TD]
[TD]Liz
[/TD]
[TD][/TD]
[TD]Dave
[/TD]
[TD]1:12
[/TD]
[TD]37
[/TD]
[/TR]
[TR]
[TD]54
[/TD]
[TD]7:30
[/TD]
[TD]Sarah
[/TD]
[TD][/TD]
[TD]Mike
[/TD]
[TD]9:00
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD]9:00
[/TD]
[TD]Mike
[/TD]
[TD][/TD]
[TD]Matt
[/TD]
[TD]3:14
[/TD]
[TD]82
[/TD]
[/TR]
</tbody>[/TABLE]

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.