VBA highlight "time Lap" codes

[motilulla]

Hello,

1-I have part sold code list in the columns B, C and D
2-part code sold "Time Lap" in the columns G, H and I

I want to have VBA, which can highlight part code list in the columns B, C and D...once the "Time Lap" range is selected in the columns G, H and I

For example if I select the range G25:I25 and run the macro so the macro highlight for me range B25:D25 as per "Time Lap" as shown in the image attached.

I need macro to highlight them for fixing the format and if possible also to have a 2nd option "Worksheet change" event code which can work and highlight selecting different ranges in the columns G:H

*	A	B	C	D	E	F	G	H	I	J	K
1							Time Lap	Time Lap	Time Lap
2		Store1	Store2	Store3			Among 3 Stores	Among 3 Stores	Among 3 Stores
3		Parts Code Sold	Parts Code Sold	Parts Code Sold			Store1	Store2	Store3
4		48	98	134			0	0	0
5		65	97	126			0	0	0
6		90	101	115			0	0	0
7		81	73	131			0	0	0
8		45	82	137			0	0	0
9		84	106	116			0	0	0
10		45	76	119			2	0	0
11		80	101	134			0	5	7
12		64	108	122			0	0	0
13		57	99	139			0	0	0
14		98	113	113			10	14	14
15		75	86	127			0	0	0
16		81	77	137			9	0	8
17		58	109	104			0	0	0
18		84	108	133			9	6	0
19		71	106	140			0	10	0
20		78	88	140			0	0	1
21		87	103	139			0	0	8
22		60	79	135			0	0	0
23		55	111	104			0	0	6
24		56	93	126			0	0	19
25		86	116	133			10	16	7
26		78	89	112			6	0	0
27		86	80	133			2	16	2
28		56	104	117			4	5	0
29		86	91	97			2	0	24
30		73	119	105			23	20	0
31		96	93	132			0	7	0
32		86	114	139			3	0	11
33		80	78	88			6	7	13
34		94	85	126			0	0	10
35		97	112	110			6	9	0
36		82	65	112			28	31	1
37		89	78	98			11	4	23
38		83	103	123			0	17	0
39		94	74	111			5	0	16
40		93	73	102			9	10	0
41		70	99	119			0	28	11
42		55	107	123			19	0	4
43		95	117	132			0	15	12
44		76	98	123			34	7	2
45		67	109	134			0	28	34
46		95	94	118			3	7	0
47		99	87	111			6	26	8
48		84	112	132			30	12	5
49
50

Thank you all.

I am using Excel 2000

Regards,
Moti

 

[motilulla]

Hello,

May be my question is wrong i want to correct here...instead of selecting range G25:I25...we can select the range B25:D25 and then pick the "Lap Value" from range G25:I25 and highlight the selected codes...

For example...

Code 86 highlighted "Lap Value" 10 rows back,
Code 116 highlighted "Lap Value" 16 rows back,
Code 133 highlighted "Lap Value" 7 rows back

Does this could be viable?

Thank you all.

I am using Excel 2000

Regards,
Moti