Calendar fformatting

[John thomas]

Hi I have made a calendar using 42 text boxes which works brilliantly .It uses an array with 3 columns .The second column shows the installers Surname .What i would like to do is colour each installers name with there unique colour That way when looking at the complete 42 text boxes the various installers names will stand out .
Any ideas please

 

[John thomas]

HI Unc No That is not the Case
Each of the 42 text boxes are populated by an array the array has 3 columns the first row shows the customer surname the 2nd Column has the fitters surname the 3rd column has customer tele number
I want to show only the fitters Surname in a unique colour not the other 2 columns

 

[moke123]

how about rich text and add html markup