Conditional Formatting - searching for match with string split across 2 columns

[jbrouse]

Greetings,

I need some assistance with a conditional formatting formula.

In column C, I have a list of 13-digit base part numbers. In column D, I have a 2-digit location code that would get added as a suffix to make a complete 15-digit part no.

I need help to develop conditional formatting on cell A1 to highlight green if the entered full part no. exists in my list. This will require the conditional formatting formula to "combine" the values in column C and D, i.e., find the left 13 digits of the part no. in column C, and if found, if the location code found in the same row, column D matches the right 2 digits of the search value, highlight it green.

Can anyone please help?

Thank you in advance!

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D
1	123456789012513
2			1234567890123	11
3			1234567890124	12
4			1234567890125	13
5			1234567890126	14
6			1234567890127	15
7			1234567890128	16
8			1234567890129	17
9			1234567890130	18
10			1234567890131	19
11			1234567890132	20
12			1234567890133	21
13			1234567890134	22
14			1234567890135	23
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=MATCH($A$1&"",$C$2:$C$14&$D$2:$D$14,0)	text	NO

 

[DanteAmor]

Try this
=COUNTIFS(C:C,LEFT($A$1,13),D:D,RIGHT($A$1,2))