Hi guys,
I'm trying to loop though the characters of a cell's value looking for a word, once the word is found I want to change its font colour
I am using the Instr function to find the first instance of a word, however I wish to colour EVERY instance of the word in the string.
How do you loop through each found instance?
What I am currently using finds the first instance correctly:
Kind regardsPlease Login or Register to view this content.
Jordan
Bookmarks