You can have parts of text constants in one cell be different sizes, fonts, color, by selecting the text and using the tools from the formatting features in the Home tab.

Here,

the word “Text” is selected, and the red font color is being applied. Only the word “Text” will be red. You can also access the font by right-clicking once the word is selected.