MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

how to color numeric character in excel cell ?

  Asked By: Emily    Date: Nov 20    Category: MS Office    Views: 1727

how can i color numeric Characters in excel cell with specific color
and text Characters with different color



5 Answers Found

Answer #1    Answered By: Leon Evans     Answered On: Nov 20

try using a formula in custom format, eg if(>1000000,[red],[blank]

Answer #2    Answered By: Garai Chalthoum     Answered On: Nov 20

but it dosent work !!!!!!!!!!!!!!

Answer #3    Answered By: Caitlin Brown     Answered On: Nov 20

This is the generic method for applying color  to part of a cell.

ActiveCell.Characters(Start:=3, Length:=3).font _

You would vary the Start, Length, and ColorIndex for the result you want.

I would have a for-next loop to step through the relevant cells
In that I would have a for-next loop to step through the characters  in the
In that I would have a select case structure based on the code of each
character to set the color index
Immediately after the end select you have the line to set the color of the

Answer #4    Answered By: Mamie Wallace     Answered On: Nov 20

but the possition of the numeric  character is deferent form cell  to
i found this code in google groups

Sub BoldTwos()
Dim c As Range
Dim s As Long
Const Twos As String = "2"

For Each c In Selection
s = 1
With c
.NumberFormat = "@"
.Value = CStr(.Value)
Do While InStr(s, c.Text, Twos) > 0
s = InStr(s, c.Text, Twos)
.Characters(s, 1).Font.Bold = True
.Characters(s, 1).Font.Color = vbRed
s = s + 1
End With
Next c

End Sub
but i need to bold an color  all numbers 1'2'3'4'5'6'7'8'9'0

Answer #5    Answered By: Randy Warren     Answered On: Nov 20

That is why I told you to step through the characters  in the cell  and color
each one.

Didn't find what you were looking for? Find more on how to color numeric character in excel cell ? Or get search suggestion and latest updates.