Need conditional format formula

[sunwordelite]

need formula i have column number specify key in digit 13567

column A mix rumber by row how to highlight in condiotional format by background colour or colour number and get sort the highlited number in column B.Any help would be appreciated..thank you

 

[Eric W]

Try:

Book1
	A	B	C	D	E
1				key in
2				15367
3
4			A		B
5			1234		1234
6			5678		5678
7			2567		2567
8			1237		1237
9			5671		5671
10			3576		3576
11			4892
12			8902
13
Sheet15

Cell Formulas
Range	Formula
E5:E13	E5	=IFERROR(INDEX($C:$C,AGGREGATE(15,6,ROW(C$5:C$12)/SIGN(MMULT(--ISNUMBER(FIND(MID($D$2,TRANSPOSE(ROW(INDIRECT("1:"&LEN($D$2)))),1),$C$5:$C$12)),ROW(INDIRECT("1:"&LEN($D$2))))),ROWS($E$5:$E5))),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C5:C13	Expression	=OR(ISNUMBER(FIND(MID(C5,ROW(INDIRECT("1:"&LEN(C5))),1),$D$2&"")))	text	NO