Is it possible to have 2 different colors for a numeric cell?

[AshrafFouad]

Hi,
I have a numeric cell formatted as (#,##0 "Meters") to display --> e.g. 112 Meters
Is it possible to display the text "Meters" in a different color? --> e.g. 112 Meters

Thank you.

 

[mahmed1]

Hi

Does this work. (#,##0 [Red]”Meters")

 

[VBE313]

two font colors in one cell

Hi, My workbook and worksheets are protected by password. I want to use two colors in a cell, red and green. Can I unprotect the sheet1 while the cell is used by user, then after finishing entering text, can I protect again? This way I think users can use two font colors. Can I do this in...

www.mrexcel.com

 

[AshrafFouad]

two font colors in one cell

Hi, My workbook and worksheets are protected by password. I want to use two colors in a cell, red and green. Can I unprotect the sheet1 while the cell is used by user, then after finishing entering text, can I protect again? This way I think users can use two font colors. Can I do this in...

www.mrexcel.com

Thanks for responding.
It did change both (Number & text) to the red color.

 

[AshrafFouad]

Thanks for responding.
It did change both (Number & text) to the red color.

Hi

Does this work. (#,##0 [Red]”Meters")

Thanks for responding.
It did change both (Number & text) to the red color.

 

[Fluff]

As was pointed out by VBE313, it is not possible to do what you are asking for.

 

[AshrafFouad]

two font colors in one cell

Hi, My workbook and worksheets are protected by password. I want to use two colors in a cell, red and green. Can I unprotect the sheet1 while the cell is used by user, then after finishing entering text, can I protect again? This way I think users can use two font colors. Can I do this in...

www.mrexcel.com

Sorry, the previous reply was not for you and I didn't find an edit button to my post.
For such post you shared, if the cell content is text, it is possible to have many colors in one cell, but I'm looking for many colors for a numeric field.

 

[Fluff]

Please see post#6.

 

[AshrafFouad]

As was pointed out by VBE313, it is not possible to do what you are asking for.

Thanks for responding & sorry for being late.
I found a solution, it is a workaround but the result is satisfactory.
In Microsoft community & through VBA they merge 2 cells (one numeric & the other is text in my case) with different colors in one cell with the same colors.
The displayed result after modifying the code:

Sub merge()
'Starts on the first cell
Value1 = ActiveCell.Value
Color1 = ActiveCell.Font.Color
Len1 = Len(Value1)

Value2 = "Meter"
Color2 = 1256897
Len2 = 5

ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.Value = Value1 & " " & Value2
With ActiveCell.Characters(Start:=1, Length:=Len1).Font
    .Color = Color1
End With
With ActiveCell.Characters(Start:=Len1 + 2, Length:=Len2).Font
    .Color = Color2
End With
ActiveCell.Offset(1, -1).Range("A1").Select
End Sub

The only cons of this method, it is not updating automatically the "displayed text" if I changed the "value"

 

[Fluff]

Glad you sorted it & thanks for the feedback