Multi-colour And multi lines in one cell

[Saleem]

Gentelmen
1)
Need to know of a function which enable me to have multi
color text in one cell,

2) is there is away to have a bullet at the begining in
multi line cell

[Gord Dibben]

Saleem

1. Adapt the following for multi-colored font in a cell

Sub CellFont()
With ActiveCell.Characters(Start:=1, length:=3).Font
.ColorIndex = 3
.Bold = True
.Underline = True
End With
With ActiveCell.Characters(Start:=4, length:=3).Font
.Superscript = True
.ColorIndex = 5
End With
End Sub

2. Enter a bullet using ALT + 0149(enter via the number pad...not regular
number keys).....Wingdings font yields some interesting bullets.....open Char
Map to view.

HTH Gord Dibben Excel MVP - XL97 SR2

[saleem]

Thanks you,
I'm actually after excel function and not VBA

>.
>

[Chip Pearson]

It can't be done with a worksheet function. Functions can return a value (e.g,
a number or some text) and then that entire value is formatted according the
cell's formatting specifications. You can't format parts of a cell if the cell
contains a formula.

It would be nice, but it can't be done.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"saleem" <23au...@omantel.net.om> wrote in message
news:372f01c28150$cbdab4f0$2ae2...@phx.gbl...