Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting: different fonts colors for the same text
Hello! Friends:
With Conditional Formatting, is it possible to have different font colors (say 2 colors) in the SAME cell? Note: I am using LEFT, and MID functions to control the start of the 2 colors of the text value in a single cell. Appreciate any advice. Lee CC ---------------------------------------------------------- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting: different fonts colors for the same text
hi
multiple formats in a cell is dependent on hard TEXT only. it don't apply to formulas or number unless the number are foramted as text. reason...multiple formats depend on specific, exact start and stop points and formulas can return more(or less) data than the formula itself. personally, i have never tried it with CF but when you mentioned the Left and Mid function.....probably not. maybe someonewill prove me wrong and i will learn something. regards FSt1 "LeeCC" wrote: Hello! Friends: With Conditional Formatting, is it possible to have different font colors (say 2 colors) in the SAME cell? Note: I am using LEFT, and MID functions to control the start of the 2 colors of the text value in a single cell. Appreciate any advice. Lee CC ---------------------------------------------------------- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting: different fonts colors for the same te
Thanks for the reply.
If LEFT and MID functions are not good ways, perhaps you could suggest some other methods. For example, "APPLE", I want "AP" to be in blue, and "PLE" to be in red. Lee CC -------------------------------------------------------------- "FSt1" wrote: hi multiple formats in a cell is dependent on hard TEXT only. it don't apply to formulas or number unless the number are foramted as text. reason...multiple formats depend on specific, exact start and stop points and formulas can return more(or less) data than the formula itself. personally, i have never tried it with CF but when you mentioned the Left and Mid function.....probably not. maybe someonewill prove me wrong and i will learn something. regards FSt1 "LeeCC" wrote: Hello! Friends: With Conditional Formatting, is it possible to have different font colors (say 2 colors) in the SAME cell? Note: I am using LEFT, and MID functions to control the start of the 2 colors of the text value in a single cell. Appreciate any advice. Lee CC ---------------------------------------------------------- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting: different fonts colors for the same te
I think you will have to go with VBA to get your multiple fonts in a cell.
Here is some sample code. Perhaps you can adjust to suit. Sub CellFont() With ActiveCell.Characters(Start:=1, Length:=5).Font .ColorIndex = 3 .Bold = True .Underline = True .Size = 14 End With With ActiveCell.Characters(Start:=6, Length:=3).Font .Superscript = True .ColorIndex = 5 End With With ActiveCell.Characters(Start:=10, Length:=4).Font .Bold = True .Size = 18 .ColorIndex = 6 End With End Sub Gord Dibben MS Excel MVP On Sat, 20 Dec 2008 19:06:01 -0800, LeeCC wrote: Thanks for the reply. If LEFT and MID functions are not good ways, perhaps you could suggest some other methods. For example, "APPLE", I want "AP" to be in blue, and "PLE" to be in red. Lee CC -------------------------------------------------------------- "FSt1" wrote: hi multiple formats in a cell is dependent on hard TEXT only. it don't apply to formulas or number unless the number are foramted as text. reason...multiple formats depend on specific, exact start and stop points and formulas can return more(or less) data than the formula itself. personally, i have never tried it with CF but when you mentioned the Left and Mid function.....probably not. maybe someonewill prove me wrong and i will learn something. regards FSt1 "LeeCC" wrote: Hello! Friends: With Conditional Formatting, is it possible to have different font colors (say 2 colors) in the SAME cell? Note: I am using LEFT, and MID functions to control the start of the 2 colors of the text value in a single cell. Appreciate any advice. Lee CC ---------------------------------------------------------- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting: different fonts colors for the same te
Thanks, Mr. Dibben
Got it. I will work on your sample codes. LeeCC ------------------------------------------------------------------------- "Gord Dibben" wrote: I think you will have to go with VBA to get your multiple fonts in a cell. Here is some sample code. Perhaps you can adjust to suit. Sub CellFont() With ActiveCell.Characters(Start:=1, Length:=5).Font .ColorIndex = 3 .Bold = True .Underline = True .Size = 14 End With With ActiveCell.Characters(Start:=6, Length:=3).Font .Superscript = True .ColorIndex = 5 End With With ActiveCell.Characters(Start:=10, Length:=4).Font .Bold = True .Size = 18 .ColorIndex = 6 End With End Sub Gord Dibben MS Excel MVP On Sat, 20 Dec 2008 19:06:01 -0800, LeeCC wrote: Thanks for the reply. If LEFT and MID functions are not good ways, perhaps you could suggest some other methods. For example, "APPLE", I want "AP" to be in blue, and "PLE" to be in red. Lee CC -------------------------------------------------------------- "FSt1" wrote: hi multiple formats in a cell is dependent on hard TEXT only. it don't apply to formulas or number unless the number are foramted as text. reason...multiple formats depend on specific, exact start and stop points and formulas can return more(or less) data than the formula itself. personally, i have never tried it with CF but when you mentioned the Left and Mid function.....probably not. maybe someonewill prove me wrong and i will learn something. regards FSt1 "LeeCC" wrote: Hello! Friends: With Conditional Formatting, is it possible to have different font colors (say 2 colors) in the SAME cell? Note: I am using LEFT, and MID functions to control the start of the 2 colors of the text value in a single cell. Appreciate any advice. Lee CC ---------------------------------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with fonts | Excel Worksheet Functions | |||
Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
Conditional Formatting - Not all colors work? | New Users to Excel | |||
Conditional Formatting with Colours / Colors | Excel Worksheet Functions | |||
Conditional Formatting in 6 colors | Excel Discussion (Misc queries) |