Diff colours in same sentence inc a formula

B

bookman3

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
 
G

Gord Dibben

No.

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


Gord Dibben MS Excel MVP
 
Top