Index text so that the formatting still applies.

I have index some text from another spreadsheet but the text formatting (colour) is lost. Is there a way to make it carry across?

Thanks