Format Paricular Text Character from range

[HaroonSid]

hi,
i am using below to change the font color if particular text character found in range
it will format the range h8:h300 if found x value ( "BB PT" )

Please Login or Register  to view this content.

I WANT MULTIPLE TEXT CHARACTER
For example

"BB PT"
"N PT"
"BBB PT"

IF found all above three text character then format the text

thank you

[YasserKhalil]

Hello Haroon
Try this code

Please Login or Register  to view this content.

[davsth]

Your code formats the text in the cell including and after the match

Does the bit after the match need shading? if not change Len(Found) to len(x)
do you only wish to shade cells if all 3 conditions are true, or if any of the conditions are true?

[jindon]

Please Login or Register  to view this content.

[HaroonSid]

I wish to shade cells if any of the one conditions are true or two condition are true or there conditions are true

[jindon]

Upload a workbook clearly showing before/after.

[HaroonSid]

Please Login or Register  to view this content.

HI Jindon Sir
this code is working perfectly as i ask

but i want to change font of all text after these character
"BB PT"
"N PT"
"BBB PT"

as my first code is doing

btw
thank you very much

[jindon]

Then try change to

Please Login or Register  to view this content.

[HaroonSid]

Total perfect
Jindon Sir

thank you very very much

[HaroonSid]

but sir if you don't mind
i have a query in my mind
in below code what presents 2,3

Please Login or Register  to view this content.

[jindon]

Onside {} represents number of appearance of preceding character.
In this case "B"
So (BB or BBB or N) & " PT"

[HaroonSid]

MasterMind, Sir

Programming is just awesome to do Work Fast, Easily and accurately,

I love this site