Highlight 2nd Occurrence of a Specific Character in Cell

[chingching831]

Hi there,

Is there an excel formula or VBA code that can highlight the 2nd occurrence of a specific character in cell? For example, the letter "B" appears twice in the cell, how can I highlight the second "B" in blue?

BATBML

Thanks,
Ching

 

[chingching831]

If the cell contains a formula, you cannot colour individual characters. You would have to replace the formula with whatever that formula's results is and then you could colour a character as per @Fuji's code above.

Got it, thanks Peter!

 

[Fuji]

chingching831,​

If the cell is Numeric or formula, you can't change the cell partially, so you will need to convert the cell as text sting.

 

[Peter_SSs]

Got it, thanks Peter!

Cheers.