How to change color of partial string

[ThrottleWorks]

Hi,

I have a string. I need to change color of partial characters from that string.
How do I do this. Can anyone please help me in this.

Input - > Bike riding is awesome
Output -> Bike riding is awesome (font color is red and bold).

Length of awesome is fixed.

 

[Deepak]

If u are going to print the same in xl then check this..

http://forum.chandoo.org/threads/fo...ll-with-specific-font-type.28885/#post-172850


If on msgbox. Then not possible but you may use userform for the same.

 

[ThrottleWorks]

Thanks a lot @Deepak sir, I am checking this. Will revert with details.

Good night. Have a nice weekend.

 

[ThrottleWorks]

Hi @Deepak sir, I know that you know, you are a rockstar. But let me say it once again. You are awesome ! Thanks a lot.