Macropod, thank you so much.
I have been a little while getting back to you as I have absolutely no idea how to implement macros. However, with a little experimentation I have got it to work.
All my colours are in the format of six figure numbers, the green I have called for is 0040FF so I changed the part of your green line
.Text = "\[color=green\](*)\[/color\]"
to
.Text = "\[color=00400FF\](*)\[/color\]"
and got green writing in bold.
Perfect.
I can now go through and change all the other colours I am using and other formats hopefully and get it all to work.
Thank you for that.
Bob.