VBA highlight "time Lap" codes

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
2,049
Office Version
  1. 2003 or older
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

*ABCDEFGHIJK
1Time LapTime LapTime Lap
2Store1Store2Store3Among 3 StoresAmong 3 StoresAmong 3 Stores
3Parts Code SoldParts Code SoldParts Code SoldStore1Store2Store3
44898134000
56597126000
690101115000
78173131000
84582137000
984106116000
104576119200
1180101134057
1264108122000
135799139000
1498113113101414
157586127000
168177137908
1758109104000
1884108133960
19711061400100
207888140001
2187103139008
226079135000
2355111104006
2456931260019
258611613310167
267889112600
2786801332162
2856104117450
298691972024
307311910523200
319693132070
32861141393011
338078886713
3494851260010
3597112110690
36826511228311
3789789811423
38831031230170
3994741115016
4093731029100
41709911902811
42551071231904
439511713201512
4476981233472
456710913402834
469594118370
4799871116268
488411213230125
49
50

Thank you all.

I am using Excel 2000

Regards,
Moti
 

Attachments

  • Highlight Time Lap.png
    Highlight Time Lap.png
    49.7 KB · Views: 7

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
2,049
Office Version
  1. 2003 or older
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
 

Forum statistics

Threads
1,147,820
Messages
5,743,387
Members
423,792
Latest member
travisds

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top