Format Half of a Cell

[waynehinds]

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.

[Rowan]

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
>
>