Format single character
On Thu, 16 Apr 2009 11:49:23 -0700 (PDT), alex wrote:
Hello All,
Using Excel '07...
Is there a way to use conditional formatting (or something else) to
color a single character in a string.
E.g., change the color of the fifth character in a cell?
alex
Only if it is a string, and not the result of a formula.
Select the cell and go into edit mode. Then select the character and format
it.
This could also be done with VBA:
To enter this Macro (Sub), <alt-F11 opens the Visual Basic Editor.
Ensure your project is highlighted in the Project Explorer window.
Then, from the top menu, select Insert/Module and
paste the code below into the window that opens.
To use this Macro (Sub), <alt-F8 opens the macro dialog box. Select the macro
by name, and <RUN.
=========================
Option Explicit
Sub Red5Char()
Dim c As Range
Set c = Selection
If c.Count < 1 Then Exit Sub
If Len(c.Text) < 5 Then Exit Sub
c.Characters(5, 1).Font.Color = vbRed
End Sub
==========================
--ron
|