How to bold specific characters in a cell using VBA or replace function in excel?

Hi guys,

I have a table where each cell contains number of specific codes and I am trying to find a way to bold only those codes in those cells.

I have attached the sample workbook below.

I already know that it is not possible to do this using the excel formula.

however, VBA or other excel functions that I can perhaps use to achieve this?

Many thanks in advance.

Kind regards,

Jin

jjin

This should do

Please Login or Register  to view this content.

Thank you mikerickson and Jindon. It both works. much appreciated.

Hi jindon,

Your code does what I want to achieve however it is very slow when i applied it to my worksheet where there are more than 6,000 rows.

Is there any way I can apply the code without freezing my screen for long time?

Thank you in advance.

Originally Posted by jjin

Your code does what I want to achieve however it is very slow when i applied it to my worksheet where there are more than 6,000 rows.

Is there any way I can apply the code without freezing my screen for long time?

Normally changing cell format would take time and I can only think of setting ScreeUpdating property to false in the beginning and set it back to true at the end..

Thank you. I will try with screenupdating code Hope it will make the code faster. Many thanks.