Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to change list text to 2 colors?
I have a list that I want to show two different colors of text in one cell.
I validated the list with the color changes. example: 1200 1 1330 1 I have the "1" as white, so ideally it would blend in with the background and you would only see the 1200 or 1330. However it's defaulting "1" back to black text. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to change list text to 2 colors?
hi
yes it is possible. but it's very specific. works on text or number formated as text only. no real numbers or formulas. is all your data the same format as the example you posted? what column is the data in? how long is your list? post back with more info. regards FSt1 "RaY" wrote: I have a list that I want to show two different colors of text in one cell. I validated the list with the color changes. example: 1200 1 1330 1 I have the "1" as white, so ideally it would blend in with the background and you would only see the 1200 or 1330. However it's defaulting "1" back to black text. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to change list text to 2 colors?
Well, the list is located in G23:G29. This is what in list. 1200 1, 1200 D 1,
1330 1, 1330 D 1, 1430 1 and 1530 1. If its not possible with these times maybe make a list within a list to make it work? I'm not sure what my limits are. -Ray "FSt1" wrote: hi yes it is possible. but it's very specific. works on text or number formated as text only. no real numbers or formulas. is all your data the same format as the example you posted? what column is the data in? how long is your list? post back with more info. regards FSt1 "RaY" wrote: I have a list that I want to show two different colors of text in one cell. I validated the list with the color changes. example: 1200 1 1330 1 I have the "1" as white, so ideally it would blend in with the background and you would only see the 1200 or 1330. However it's defaulting "1" back to black text. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to change list text to 2 colors?
hi
sorry it took so long to get back. got past my bed time. you have a short list. manually... click into the formula bar and highlight the text you wish to format. right click the formula bar. note that you can only format text. format the text to your liking. clcik ok. press enter. next cell. code..... i was anticipating a longer list so i wrote a small macro. Sub RaY() Dim r As Range Set r = Range("G23", Range("G23").End(xlDown)) 'change above cell reference if needed For Each cell In r With cell.Characters(Start:=6, Length:=1).Font .ColorIndex = 2 End With Next cell End Sub regards FSt1 "RaY" wrote: Well, the list is located in G23:G29. This is what in list. 1200 1, 1200 D 1, 1330 1, 1330 D 1, 1430 1 and 1530 1. If its not possible with these times maybe make a list within a list to make it work? I'm not sure what my limits are. -Ray "FSt1" wrote: hi yes it is possible. but it's very specific. works on text or number formated as text only. no real numbers or formulas. is all your data the same format as the example you posted? what column is the data in? how long is your list? post back with more info. regards FSt1 "RaY" wrote: I have a list that I want to show two different colors of text in one cell. I validated the list with the color changes. example: 1200 1 1330 1 I have the "1" as white, so ideally it would blend in with the background and you would only see the 1200 or 1330. However it's defaulting "1" back to black text. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
How do I change the 10 default text colors in Office 2007 | Excel Discussion (Misc queries) | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
CELL & TEXT COLORS DO NOT CHANGE ON MY PC MONITOR | Excel Discussion (Misc queries) | |||
How do I change row text colors in Excel based on formula? | Excel Discussion (Misc queries) |