C
chetan
i want to make a cell with multicolor text......... how to do it in
bulk(e.g as we do it in replace all)
bulk(e.g as we do it in replace all)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein \(MVP - VB\)
If the text displayed in the cell is the result of a formula in that cell,
you cannot have more than one color. If your data is a pure text entry, you
can have multi-colored text, but you will need to use a macro to do more
than one cell at a time. If your cell entries are second condition (pure
text), then give us more information about what you want to do.
Rick
you cannot have more than one color. If your data is a pure text entry, you
can have multi-colored text, but you will need to use a macro to do more
than one cell at a time. If your cell entries are second condition (pure
text), then give us more information about what you want to do.
Rick
C
chetan
If the text displayed in the cell is the result of a formula in that cell,
you cannot have more than one color. If your data is a pure text entry, you
can have multi-colored text, but you will need to use a macro to do more
than one cell at a time. If your cell entries are second condition (pure
text), then give us more information about what you want to do.
Rick
- Show quoted text -
ya it is pure text............ in the sense that there are some
numbers other than characters..... but not a formula...........
those can be considered as text...........
could you please help me out....... i have no idea about programming
macros in VB... i just know how to record it
R
Rick Rothstein \(MVP - VB\)
i want to make a cell with multicolor text......... how to do it in
Okay, the next thing you need to tell us is what part of the text you want
to color... The text at a certain offset? Certain specific words? Certain
types of words (your numbers perhaps)? In other words, we need to know the
rule you have that will make one part of the text get colored differently
than the rest. There is no way we can give you working code if we don't know
what to color and what to leave uncolored.
Rick
ya it is pure text............ in the sense that there are some
numbers other than characters..... but not a formula...........
those can be considered as text...........
could you please help me out....... i have no idea about
programming macros in VB... i just know how to record it
Okay, the next thing you need to tell us is what part of the text you want
to color... The text at a certain offset? Certain specific words? Certain
types of words (your numbers perhaps)? In other words, we need to know the
rule you have that will make one part of the text get colored differently
than the rest. There is no way we can give you working code if we don't know
what to color and what to leave uncolored.
Rick