For each instance of word in string

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:

Please Login or Register  to view this content.

Kind regards
Jordan