Finding cells with same values and identifying them

[Rolandkroon]

Good Morning.
I have a list of Customer Codes and a list of Customer codes who use a certain kind of billing in a separate column (or sheet)
I need to search the second column so that I can highlight the customers that use this billing method.
Column 1 Cust Code - I need to find all the Cust Codes that appear in both Column 1 and Column 3 "debit Order"
Your assistance is highly appreciated.
Thank
Roland

Cust Code	Contact	Debit Order
AAS001	AA Safaris	ABE002
ABE002	Colin Rudolph Edger Abels	ADA007
ABR001	Whities Abrahams	AFR004
ABR002	Sharon Abrahams	AGT001
ABR003	Protea Boniswa Abrahams	ALE002
ADA001	Shastri Adams	ALE003
ADA002	Gerrith Adams	API001
ADA003	Marita Adams	ATH001
ADA005	Petro Adams	BAA003
ADA006	Lavande Adams	BAA009
ADA008	Stephen Adams	BAA010
ADA009	Hillary Stacey Adams	BAB001
ADA010	John Adams	BAR003
AFPP(C	Alexandria Farm Protection Plan	BAR004
AFR004	Klasie Afrika	BEY001

 

[awoohaw]

Here is conditional formatting scenario:

I do not know how to assign a different color to each match, though.

Mr excel questions 53.xlsm
	A	B	C	D	E	F	G	H
1	Cust Code	Contact	Debit Order		CF Formula A in C	CF Formula Text	CF Formula C in A	CF Formula Text
2	AAS001	AA Safaris	ABE002		FALSE	=ISNUMBER(MATCH(A2,$C$2:$C$16,0))	TRUE	=ISNUMBER(MATCH(C2,$A$2:$A$16,0))
3	ABE002	Colin Rudolph Edger Abels	ADA007		TRUE	=ISNUMBER(MATCH(A3,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C3,$A$2:$A$16,0))
4	ABR001	Whities Abrahams	AFR004		FALSE	=ISNUMBER(MATCH(A4,$C$2:$C$16,0))	TRUE	=ISNUMBER(MATCH(C4,$A$2:$A$16,0))
5	ABR002	Sharon Abrahams	AGT001		FALSE	=ISNUMBER(MATCH(A5,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C5,$A$2:$A$16,0))
6	ABR003	Protea Boniswa Abrahams	ALE002		FALSE	=ISNUMBER(MATCH(A6,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C6,$A$2:$A$16,0))
7	ADA001	Shastri Adams	ALE003		FALSE	=ISNUMBER(MATCH(A7,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C7,$A$2:$A$16,0))
8	ADA002	Gerrith Adams	API001		FALSE	=ISNUMBER(MATCH(A8,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C8,$A$2:$A$16,0))
9	ADA003	Marita Adams	ATH001		FALSE	=ISNUMBER(MATCH(A9,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C9,$A$2:$A$16,0))
10	ADA005	Petro Adams	BAA003		FALSE	=ISNUMBER(MATCH(A10,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C10,$A$2:$A$16,0))
11	ADA006	Lavande Adams	BAA009		FALSE	=ISNUMBER(MATCH(A11,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C11,$A$2:$A$16,0))
12	ADA008	Stephen Adams	BAA010		FALSE	=ISNUMBER(MATCH(A12,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C12,$A$2:$A$16,0))
13	ADA009	Hillary Stacey Adams	BAB001		FALSE	=ISNUMBER(MATCH(A13,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C13,$A$2:$A$16,0))
14	ADA010	John Adams	BAR003		FALSE	=ISNUMBER(MATCH(A14,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C14,$A$2:$A$16,0))
15	AFPP(C	Alexandria Farm Protection Plan	BAR004		FALSE	=ISNUMBER(MATCH(A15,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C15,$A$2:$A$16,0))
16	AFR004	Klasie Afrika	BEY001		TRUE	=ISNUMBER(MATCH(A16,$C$2:$C$16,0))	FALSE	=ISNUMBER(MATCH(C16,$A$2:$A$16,0))
17
RolandKroon

Cell Formulas
Range	Formula
E2:E16	E2	=ISNUMBER(MATCH(A2,$C$2:$C$16,0))
F2:F16,H2:H16	F2	=FORMULATEXT(E2)
G2:G16	G2	=ISNUMBER(MATCH(C2,$A$2:$A$16,0))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:C16	Expression	=ISNUMBER(MATCH(C2,$A$2:$A$16,0))	text	NO
A2:A16	Expression	=ISNUMBER(MATCH(A2,$C$2:$C$16,0))	text	NO

 

[awoohaw]

I just realized the picture I posted did not have the rules: