Highlight Text and Change Font Color (HTML) | Excel VBA Macro

[@nathanfinneran8417]

Greg, your Excel VBA videos have been extremely helpful as I have been working to automate mass emails. I am extremely grateful as you have saved me hours of mindless copy and pasting!

[@greggowaffles]

So glad to hear that!! My pleasure

[@ElizabethRivera-yu9hh]

OMG this is great and well explained. You have no idea how long I’ve been searching to learn how to highlight text and/or change font color to text in macro. Thank you so much!

[@greggowaffles]

So glad to hear that! Thank you for watching!!

[@aashishmeshram9892]

you are awesome Greg. thanks for your ultimate videos !! keep rocking

[@greggowaffles]

Appreciate the kind words! Thanks for watching!!

[@ranajsingh]

It was awesome, you saved my day.! Thanks Greg.!

[@greggowaffles]

No problem! Glad to hear that!!

[@rencerivera9171]

thanks for this lovely code: :-)

[@greggowaffles]

No prob!

[@JoshuaThomas-rd3xl]

How would I write that I want to make a piece of text Araial Black, color #650A33 and size 48pts?

[@BintonB]

Great video. Any chance you think you can paste your code into github or something?

[@hansiman9262]

how can you feed there a dynamic color code? p.e: instead "" --> "" ---> colorcodefromacell as string does not work :/

[@greggowaffles]

I’ll look into this. Thanks for reaching out

[@zahidimranx]

great trick

[@greggowaffles]

Thanks!

[@zahidimranx]

Can we also #Highlight the word China (I mean the value available in cell) ?

[@greggowaffles]

yup, you can do that. i go over that in this video: kzbin.info/www/bejne/gXWqcmeMlrOnsKc

[@rajvenkat3641]

Pls post the downloadable excel file it will be helpful

[@greggowaffles]

thanks! i'll start posting the code in the description