| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mixed font colours in a sentence | Excel Discussion (Misc queries) | |||
| How to use Add Ins / Formula Colours | Excel Discussion (Misc queries) | |||
| same formula giving diff resutls | Excel Worksheet Functions | |||
| Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
| Any formula to shorten sentence to a specific length | Excel Worksheet Functions | |||
Linear Mode
