Highlighting selected numbers in table

[Pa1234]

When I have 1 table of Excel data, my specific example is as follows:
When I enter values in the Input data box, then in the EXCEL data table cells those numbers will be marked with any color for example in the image below. I want this process to be done automatically instead of entering it manually
Please forum members help me to do it

View attachment 57207

 

[etaf]

are they always 3 digits numbers
the merged cell has 1 cell reference
or is that across multiple rows

Book2
	A	B	C	D	E	F	G	H	I	J
1
2		123	234	456	188
3		756	334	256	555			256,555,224,123,333,444,555,666,777,888,999,
4		222	223	224	225
5
6
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:E4	Expression	=AND(B2<>"",FIND(B2,$H$3,1))	text	NO

 

[Pa1234]

are they always 3 digits numbers
the merged cell has 1 cell reference
or is that across multiple rows

Book2
	A	B	C	D	E	F	G	H	I	J
1
2		123	234	456	188
3		756	334	256	555			256,555,224,123,333,444,555,666,777,888,999,
4		222	223	224	225
5
6
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:E4	Expression	=AND(B2<>"",FIND(B2,$H$3,1))	text	NO

 

[Pa1234]

are they always 3 digits numbers
the merged cell has 1 cell reference
or is that across multiple rows

Book2
	A	B	C	D	E	F	G	H	I	J
1
2		123	234	456	188
3		756	334	256	555			256,555,224,123,333,444,555,666,777,888,999,
4		222	223	224	225
5
6
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:E4	Expression	=AND(B2<>"",FIND(B2,$H$3,1))	text	NO

I don't know how to put the formula in the cell

 

[etaf]

my solution will not work where the number of digits vary - for example as a 2 will be found in any number with a 2 in so 22, 23, 234 etc

 

[Pa1234]

giải pháp của tôi sẽ không hoạt động khi số lượng chữ số khác nhau - ví dụ như số 2 sẽ được tìm thấy trong bất kỳ số nào có số 2 trong 22, 23, 234, v.v.

my solution will not work where the number of digits vary - for example as a 2 will be found in any number with a 2 in so 22, 23, 234 etc

will be 002 rather than 2. they are all 3-digit numbers. Your solution worked but I don't know how to add them in excel. Please give an example with a specific picture

 

[etaf]

They need to be entered as TEXT
Numbers will remove the leading zero's and formatting will not resolve - as we are using find to find exact match - NOT a formatting
so 2
must be Text entered as 002


for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
B6:D15 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND(B6<>"",FIND(B6,$H$5,1))

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book3
	A	B	C	D	E	F	G	H
1
2
3
4
5								002,201,030,010,004
6		002	004
7		010	020
8		100	300
9
10
11
12
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6:C8	Expression	=AND(B6<>"",FIND(B6,$H$5,1))	text	NO