Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Multi-colour And multi lines in one cell

178 views
Skip to first unread message

Saleem

unread,
Oct 31, 2002, 9:09:10 AM10/31/02
to
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

unread,
Oct 31, 2002, 2:25:52 PM10/31/02
to
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

unread,
Oct 31, 2002, 9:45:53 PM10/31/02
to
Thanks you,
I'm actually after excel function and not VBA
>.
>

Chip Pearson

unread,
Oct 31, 2002, 9:56:43 PM10/31/02
to
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...

0 new messages