I have a title (text in a cell) where I can color the font of just some words in that text, for highlighting purposes.
I had, however, to create a formula instead of the simple text, something in the lines of:
="Availability by Brand Family -" & A8 & " - Premium"
which takes text from different cells (I have over 300 of these so just typing them 300 times is not an option, when I have names like Dnipropetrovska within my text!!).
My problem now is that I cannot change the font color to words within the text, as it does not allow me anymore. Is it because the text became a formula? And is there a workaround for it, as I really need to color in red words like 'Premium', etc...