| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mixed font colours in a sentence
If I have a cell which is either concatenated or uses & between clauses, is
it possible to have the differeent element in differencolours. Or is there anothe way of achieving this? eg =concatenae("today is", H3) where H3 is a cell reference that I want in a different colour from today is. Regards -- bookman |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mixed font colours in a sentence
hi,
this can be done with hard characters but not with a formula. regards FSt1 "bookman3" wrote: If I have a cell which is either concatenated or uses & between clauses, is it possible to have the differeent element in differencolours. Or is there anothe way of achieving this? eg =concatenae("today is", H3) where H3 is a cell reference that I want in a different colour from today is. Regards -- bookman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Font Colours / negative numbers | Excel Discussion (Misc queries) | |||
| format painter wont copy mixed font colors from one cell to next | Excel Discussion (Misc queries) | |||
| mixed font styles in the output of a formula? | Excel Worksheet Functions | |||
| Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
| How to set different font colours in a cell? | Excel Worksheet Functions | |||
Linear Mode
