How to Mark specific text in a pattern BOLD through defined Variable using wildcard

My current code loops through range A62:A5000 (fixed / static range), and searches for word "PETER", wherever it find, it marks the text "PETER" Bold.

Please Login or Register  to view this content.

What I am now looking is to change the variable content, currently

Please Login or Register  to view this content.

to something like XFind = PETER SPACE and if this pattern with prefix PETER is found, to format only this portion of PETER + Pattern as bold within entire

Illustrations
PETER 4.3x ' no action PETER and anything >=5 with suffix .0x be marked as bold
PETER 5.2x ' since it is PETER blank space >=5, then entire PETER 5.2x portion be marked bold
PETER 305.2x ' since it is PETER blank space >=5, then entire PETER 305.2x portion be marked bold
PETER 2.2x ' since it is PETER blank space <5, then entire PETER 2.2x portion not be formatted

Content of any cell within Range A62:A5000 would have multiple lines (smaple workbook attached), but idea is to find where PETER + >= 5.0x is found and same (selected text in defined pattern) be formatted as bold

Without running the above code given in sample workbook, I have manually highlighted to illustrate what objective I want to achieve.

Sample Data starts from row cell A129

By responding to your own thread, you have taken it out of the unanswered threads list that many members use to find threads requiring assistance. I suggest you don't do this in future - instead, just add details to the opening post until you've had a reply.

Originally Posted by jindon

analystbank,
try

Please Login or Register  to view this content.

Worked perfectly fine. @jindon Sir.

But, I could not make out what each of the blue line does above, and where the threshold of >=5 is defined ! Just in case I have to tweak my criteria from 5 to something less or more where and how to change that threshold.

Now I am reading this page

https://www.automateexcel.com/vba/regex/

but difficult to grasp/understand at first read, and I am going slow. Please if you could elaborate.

Thanks

I know it is against the forum rules, to ask a follow up question, but since it is very close to the main query and avoding duplicate thread on main subject, I dare to ask here, how do i modify the line

Please Login or Register  to view this content.

to find and highlight in BOLD , sum where it exceeds 30,000. All sum follows after prefix = and space . Illustration explained below taken from the shared file in #1 above


DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => DOG 475 | H 18.7 L 8.75 | V 3,226, 10.3x | PETER 1.8x | Bunch 2,000 | * 17.05 = 34,100 | * 13.4 = 26,803 | * 10.5 = 21,074 | * 8.5 = 17,050 | * 4.3 = 8,525
DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => DOG 480 | H 16.2 L 7.3 | V 3,117, 4.1x | PETER 1.9x | Bunch 2,000 | * 14.8 = 29,600 | * 11.6 = 23,266 | * 9.1 = 18,293 | * 7.4 = 14,800 | * 3.7 = 7,400
DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => DOG 485 | H 13.75 L 7.05 | V 350, 5.9x | PETER 2.0x | Bunch 2,000 | * 12.6 = 25,200 | * 9.9 = 19,807 | * 7.8 = 15,574 | * 6.3 = 12,600 | * 3.2 = 6,300
DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => DOG 490 | H 11.7 L 4.8 | V 944, 3.5x | PETER 1.6x | Bunch 2,000 | * 10.6 = 21,200 | * 8.3 = 16,663 | * 6.6 = 13,102 | * 5.3 = 10,600 | * 2.7 = 5,300
DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => DOG 500 | H 8.4 L 3.5 | V 2,295, 4.3x | PETER 1.4x | Bunch 2,000 | * 7.6 = 45,200 | * 6.0 = 11,947 | * 4.7 = 9,394 | * 3.8 = 7,600 | * 1.9 = 3,800
DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => DOG 510 | H 5.9 L 2.4 | V 381, 5.6x | PETER 2.2x | Bunch 2,000 | * 5.4 = 10,800 | * 4.2 = 8,489 | * 3.3 = 6,674 | * 2.7 = 5,400 | * 1.4 = 2,700
DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => DOG 520 | H 4.2 L 1.65 | V 749, 4.2x | PETER 1.2x | Bunch 2,000 | * 3.8 = 7,600 | * 3.0 = 5,974 | * 2.3 = 4,697 | * 1.9 = 3,800 | * 1.0 = 1,900
DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => DOG 530 | H 2.95 L 1.2 | V 349, 4.6x | PETER 2.6x | Bunch 2,000 | * 2.5 = 5,000 | * 2.0 = 33,930 | * 1.5 = 3,090 | * 1.3 = 2,500 | * 0.6 = 1,250
DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => PE 475 | H 15.8 L 11 | V 306, 9.6x | PETER 3.2x | Bunch 2,000 | * 11.7 = 23,400 | * 9.2 = 18,392 | * 7.2 = 14,461 | * 5.9 = 11,700 | * 2.9 = 5,850
DIANA Zill Cl 480.0 Up 3.0 | scope 490-500-510 => PE 480 | H 18.45 L 13.25 | V 265, 13.3x | PETER 2.1x | Bunch 2,000 | * 14.35 = 28,700 | * 11.3 = 62,558 | * 8.9 = 17,737 | * 7.2 = 14,350 | * 3.6 = 7,175


I tried something like below which did not yield any result (30 because i want to highlight entire sum following after = sign and spacce as numbers with currency format of "," (comma)

.Pattern = "\b=+([30-99]|[,]|[1-9]\d+)\.\d+," ' PETER is the word to match and highlight

try

Please Login or Register  to view this content.

Just marvelous, it worked.

But not so easy for me to copy, need conceptual understanding, and I am reading some blog as suggested supra.

Am I right in observing that solution of #5 and latest modification, both are combined together !

What if i want to keep it separate for both scenarios, - which portion from this line i should remove.

Please Login or Register  to view this content.