Diff colours in same sentence inc a formula
 

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
--
bookman

Diff colours in same sentence inc a formula
 

No.

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


Gord Dibben MS Excel MVP

On Wed, 20 Jun 2007 17:28:16 -0700, bookman3
wrote:

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