| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Half of a Cell
I am wondering if it is possible to have a macro run that formats onl 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 -- waynehind ----------------------------------------------------------------------- waynehinds's Profile: http://www.excelforum.com/member.php...fo&userid=2533 View this thread: http://www.excelforum.com/showthread.php?threadid=38855 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format Half of a Cell
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First Half / Second Half Month Budget | Excel Worksheet Functions | |||
| How do I format a column to be half the size of the one above it? | Excel Discussion (Misc queries) | |||
| Compare 1st Half & 2nd Half of 2008. | Excel Worksheet Functions | |||
| Cell Paste using cell link option Half works | Excel Worksheet Functions | |||
| print half of rows on left and other half on right | Excel Discussion (Misc queries) | |||
![waynehinds[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
