Can i format part of the answer to a concatenation in a different colour? for
example: =concatenate(a1,a2,[red]a3,a4,a5)
there seems to be some sort of way using the custom cell format to use [red]
to change the colours, but i dont want it to apply to the whole text string,
just one word in it.
May not be possible but would be nice option :P