With ActiveCell.Characters(1, 3)
.Font.ColorIndex = 43
.Font.Size = 14
End With

Regards
Rowan

"waynehinds" wrote:


I am wondering if it is possible to have a macro run that formats only
part of a cell.

Say I have the following in a cell: D05 D06
I want to format only D05 in green color with 14 font size.


--
waynehinds
------------------------------------------------------------------------
waynehinds's Profile: http://www.excelforum.com/member.php...o&userid=25331
View this thread: http://www.excelforum.com/showthread...hreadid=388551