Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format single character
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format single character
Manually color = yes
Conditional formatting color = no "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format single character
On Apr 16, 3:59*pm, Ron Rosenfeld wrote:
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 Thanks for your input, Ron. This xls doc is a simple calculator that sits on a user's desktop. The user enters different numbers (8 char long) throughout the day into the same cell (only one number at a time). I would like the fith character of any number to become a certain color whenever it's typed. I'll play around with the VBA code that you provided. I don't want the user to have to envoke a marcro... alex |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format single character
On Fri, 17 Apr 2009 03:30:25 -0700 (PDT), alex wrote:
Thanks for your input, Ron. This xls doc is a simple calculator that sits on a user's desktop. The user enters different numbers (8 char long) throughout the day into the same cell (only one number at a time). I would like the fith character of any number to become a certain color whenever it's typed. I'll play around with the VBA code that you provided. I don't want the user to have to envoke a marcro... alex Alex, I don't think you can do that. You could certainly use event code to avoid your user having to execute a macro. However, the formatting will not take place until after the entire number has been entered into the cell. I don't know how to format the digits as they are being entered. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find replace excel remove single character | Excel Discussion (Misc queries) | |||
LEN fuction to leave a single character | Excel Worksheet Functions | |||
how do I make single character as a variable in an array | Excel Worksheet Functions | |||
How can I combine multiple characters into a single character? | Excel Discussion (Misc queries) | |||
Test for Single Character That is in an Array | Excel Worksheet Functions |