Format all Instances of a Word in a Range using Excel VBA
http://www.computergaga.com/blog/form... Format all instances of a word in a range using Excel VBA.
This video demonstrates a macro using VBA that will search through a range of cells for all instances of a word, and if found will format it a different colour.
This macro will only format the word if it is a whole match. It is also case sensitive.
Follow the link below for the VBA code used in the macro.
http://www.computergaga.com/blog/form...
Learn Excel VBA online
https://www.udemy.com/excel-vba-cours...
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1