Excel 2007 : Changing text colour within a strings

Hi,

I've attached a copy of the plan - sometimes its easier to see these things in the flesh than try to describe them in words!

I tried manipulating the code you posted however I could only get it to change the colour of the whole text strings rather than changing bits of it.

Hope this helps

Alan