PDA

View Full Version : Highlight number



apple
07-18-2007, 12:46 AM
Hi,

Please do show me the way to highlight 5 number in front and 5 number at the back. For example the number i want is 12345-ABC-67890.I want to highlight all the number that is 5 number in front, middle got ABC and at the back is 5 number.

Besides that i want highlight the sequence number which is start from 1 to 1.1, 1.1.1, 1.1.2 and so on. After that start loop 2 to 2.2.1,2.2.2, 2.2.3 and so on.

Below is the example:

1.1.0 12345-ABC-647891
1.1.2 67891-DEG-112345
1.1.3 78910-HIJ-123467

2.1.0 65478-KLM-645789
2.2.1 45678-OPQ-489453


I would like to highlight the number follow the sequence for number 1.1.0 to the end 1.1.3 that have 5 number in front, middle ABC and 5 number at the back. After that start loop 2.1.0 until end of 2.2.1
I am new to VBA .Thanks. Hope to hear any friend to help me soon.

Regards,
Apple

mdmackillop
07-18-2007, 10:44 AM
Hi Apple
This is not the correct forum. Is this an Excel or Word question?
Regards
MD

apple
01-14-2008, 02:11 AM
Hi,

Please close this issue. Thanks