Conditional formatting question.

[scott_86_]

Hi,

Can anyone help me out with the below?

If a number is in the left Table[Value] column, then it will be highlighted in the right 1-100 table using conditional formatting.

Using Microsoft Office Professional Plus 2016 for this query. Thanks.

 

[kevin9999]

Book1
	I	J	K	L	M	N	O	P	Q	R	S
1
2	Value
3	92		1	2	3	4	5	6	7	8	9
4	25		11	12	13	14	15	16	17	18	19
5	94		21	22	23	24	25	26	27	28	29
6	48		31	32	33	34	35	36	37	38	39
7	29		41	42	43	44	45	46	47	48	49
8	98		51	52	53	54	55	56	57	58	59
9	52		61	62	63	64	65	66	67	68	69
10	85		71	72	73	74	75	76	77	78	79
11	3		81	82	83	84	85	86	87	88	89
12	4		91	92	93	94	95	96	97	98	100
13	40
14
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K3:S12	Expression	=MATCH(K3,$I:$I,0)	text	YES