Create a Macro in Excel to reference another sheet then highlight all the same Order Numbers a unique color.

Workbook1

SR	Count	AI	Pallet	REPAIR	Inspection	ASSM	Time	Pro	FA	TEST					Total	Posted	FG	Order Number
0	0	0	0	0	0	0	0	0	0	0					80	1920	600	31942
0	0	0	0	0	0	631	0	132	0	407					2000	0	600	31892
3016	0	0	0	0	0	0	0	0	0	0					3016	0	600	31342
0	0	0	0	1	0	0	0	0	0	2					3	63	0	31982
0	0	0	0	0	0	0	0	0	0	10					10	341	0	31812
250	0	0	0	0	0	0	0	0	0	0					250	0	0	31798
0	0	0	0	0	0	0	0	0	0	2					2	122	0	35789
0	0	0	0	0	0	0	0	0	0	20					20	376	0	35418
250	0	0	0	0	0	0	0	0	0	0					250	0	0	34987
0	0	0	0	0	0	0	0	0	0	5					5	58	0	38957
0	0	0	0	0	0	0	0	0	1	7					8	46	0	39875
0	0	0	0	1	0	0	0	0	15	16					32	199	0	38742
250	0	0	0	0	0	0	0	0	0	0					250	0	0	39854
0	0	0	16	0	0	0	0	0	0	164					328	3670	240	34789
4000	0	0	0	0	0	0	0	0	0	0					4000	0	240	35874
5000	0	0	0	0	0	0	0	0	0	0					5000	0	240	35412
0	0	0	0	0	0	0	0	0	2	4					6	2002	0	35246
0	0	0	0	0	0	0	0	0	0	7					7	493	0	32546
0	0	0	0	2	0	0	0	0	2	3					7	359	0	38745
0	0	0	0	1	0	0	0	0	0	14					15	584	0	34689
0	0	0	0	0	0	0	0	5	0	4					9	631	0	35587
0	0	0	0	2	1	0	1	0	20	2					121	1279	0	32145
0	0	0	0	2	208	0	2910	20	0	60					3200	0	0	31025
3000	0	0	0	0	0	0	0	0	0	0					3000	0	0	35895
0	0	0	0	0	0	0	0	0	0	1					2	1006	0	32555

Workbook 2

Order Number

31942

31892

31342

31982

31812

31798

35789

35418

34987

38957

39875

38742

39854

34789

35874

35412

35246

32546

38745

34689

35587

32145

31025

35895