Conditional formatting with two tables and 6 columns

[odoolead1]

Hello,
I am trying to highlight duplicate items from both the tables. The goal is to highlight employee, date and amount from both tables that are duplicates. I am trying to find if all AmEx charges are posted into Accounting App.

Really appreciate your help

 

[ETAF]

not sure which table to colour
so i have added a red to table 2 if table 2 in table 1 - which i expect they all are , as its the accounting details
and a yellow to table 1 if table 1 in table 2 - which is what i think you may want to check if the contents of table1 are in table 2 and show where the same - or you could highlight where they are NOT in the table by saying =0 rather than > 0

using countif

=COUNTIFS($F$6:$F$102,$A6,$G$6:$G$102,$B6,$H$6:$H$102,$C6)
=COUNTIFS($A$6:$A$102,F6,$B$6:$B$102,G6,$C$6:$C$102,H6)

which for info only - i have added to the tables so you can see the match

ALL entries in table2 matches with TABLE 1

 

[odoolead1]

not sure which table to colour
so i have added a red to table 2 if table 2 in table 1 - which i expect they all are , as its the accounting details
and a yellow to table 1 if table 1 in table 2 - which is what i think you may want to check if the contents of table1 are in table 2 and show where the same - or you could highlight where they are NOT in the table by saying =0 rather than > 0

using countif

=COUNTIFS($F$6:$F$102,$A6,$G$6:$G$102,$B6,$H$6:$H$102,$C6)
=COUNTIFS($A$6:$A$102,F6,$B$6:$B$102,G6,$C$6:$C$102,H6)

which for info only - i have added to the tables so you can see the match

ALL entries in table2 matches with TABLE 1

Hello ETAF,
Really appreciate your help. Your solution worked great. Thanks for your help.

 

[ETAF]

you are welcome