View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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.