Diff colours in same sentence inc a formula

[Guest]

Hi

Is it possible to display a sentence in different colours where part of the
sentence is a reference to another cell

eg = Today is 21 June

where today is itext
and 21 June is a reference to another cell

I tried concatenate and the result is the test is all the same colour and
parts cannot be changed

 

[Gord Dibben]

No.

You can manually use different fonts on a string but not in a formula.


Gord Dibben MS Excel MVP