Matching Multiple Cells in Two Tables Simultaneously

QUESTION: How do you search two data tables simultaneously to find out the following:
Which customer + account + amount is found in what table?
Which customer + account + amount is found in both tables?
Which customer + account + amount is found in neither table?

IMPORTANT: All three values -- customer + account + amount -- must be matched.
The goal is to employ conditional formatting so that:
- The customer + account + amount set found in Table A is highlighted in BLUE.
- The customer + account + amount set found in Table B is highlighted in YELLOW.
- The customer + account + amount found in both tables is highlighted in GREEN.
- The customer + account + amount not found in either table is highlighted in RED.

ALSO: One table will likely contain more data than the other, ie: Table A may contain 150 records while Table B contains 200, etc.

ALTERNATIVELY
If conditional formatting is not workable, then maybe the result can identify the table(s) customer + account + amount set is found in, with the result cells looking something like this:
TABLE B
TABLE A
TABLE A & B
NOT FOUND

For an example of the data sets I have in mind, please see the Google spreadsheet at the link below.

Thank you!

LINK TO PUBLIC SPREADSHEET:
https://docs.google.com/spreadsheets...it?usp=sharing

Hello sktneer,

This is absolutely beautiful! Thank you!

One follow up question:
Is there a formula I can also use in an adjacent column to include the text indications of which table (or lack thereof) the data was found? (Similar to what is shown on the spreadsheet I posted and the one you provided.)

Example:
TABLE A & B
TABLE A
NOT FOUND
TABLE B

Kind regards,

Dave Myers

Hello sktneer,

Works flawlessly!

Thank you so much!

Kind regards,

Dave Myers