Forum Discussion

kalyani_ch1987's avatar
kalyani_ch1987
Copper Contributor
Oct 11, 2022

hi

hello. how to change the color of a part of a cell that includes numbers only. following is an example:   let's say the date is 12/10/2022 and all of it is one color.  what i want to be able to d...
excel
Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Oct 11, 2022

Hi kalyani_ch1987 

 

just click in the formula bar and highlight the part that you want to change (e.g. month). And then just select the desired font color from the ribbon:

kalyani_ch1987's avatar
kalyani_ch1987
Copper Contributor
Oct 17, 2022

Martin_Weiss 

 thank you for replaying 

 

but I am looking with out space 11101987   in his i have I want  to color 10 in red

  • sivakumarrj's avatar
    sivakumarrj
    Brass Contributor
    Oct 17, 2022
    Use Substitute formula by giving reference cell
    text in B2
    =SUBSTITUTE(B2,".","") but color will not display, it will display 11101987 after removing full stop
    (11.10.1987)

Resources