View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bookman3 bookman3 is offline
external usenet poster
 
Posts: 25
Default 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