Such as A column input id number: 51010719970308623 x
Want to get the effect of red is the color of 623 x for
That is to say, when I was in A column of the next time you enter the id number, after four color automatically become I set of red


Strives for the big help, the problems in the work, thank you

CodePudding user response:

After this, can't, I'm afraid I have to lose to use VBA macros for that a few color Settings of the characters; Or separate with separate cell to place, this is the last four,

CodePudding user response:

Conditional formatting can set style for a cell, could not be set in on parts of the cell style

CodePudding user response:

Can only use VBA, have time to learn, some simple contents or better grasp

CodePudding user response:

Suggest using mid function subtracted the required number on the color Settings

CodePudding user response:

His recording a macro, change the code, add a loop is solved,

 Sub?? () 
'
'?? ?? 
'
'????? Ctrl + e 
'
Range (" O18 "). Select 
ActiveCell. FormulaR1C1="123456" 
With ActiveCell. Characters (Start:=1, Length:=3). The Font 
.name="Calibri" 
. FontStyle="???? 
. Size=11 
The Strikethrough=False 
The Superscript=False 
The Subscript=False 
. OutlineFont=False 
The Shadow=False 
. Underline=xlUnderlineStyleNone 
. ThemeColor=xlThemeColorLight1 
. TintAndShade=0 
. ThemeFont=xlThemeFontMinor 
End With 
With ActiveCell. Characters (Start:=4, Length:=3). The Font 
.name="Calibri" 
. FontStyle="???? 
. Size=11 
The Strikethrough=False 
The Superscript=False 
The Subscript=False 
. OutlineFont=False 
The Shadow=False 
. Underline=xlUnderlineStyleNone 
Color=- 4165632 
. TintAndShade=0 
. ThemeFont=xlThemeFontMinor 
End With 
Range (" O21). Select 
End Sub 

123 456