Partial Formatting

Hi All

I'm trying to use conditional formatting to find and format a given character in a cell , and all content in the cell that follows it.

For example , with the trigger character of '&' :

John & Jill
Bill & Sarah
Julie & Steven

Would become

John & Jill
Bill & Sarah
Julie & Steven

I haven't been able to find a way via conditional formatting thus far , so I'm hoping someone can help.

Failing this , could someone suggest some VBA code to do the job? Essentially it would need to find and colour the selected character and the rest of the characters following it in the cell.

Grateful for any advice.