hi

New Contributor

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 do is change the color of a part of the date. 

how do i change the color of the month(10) portion of the date?

i know i can change the color of the full date, but i am not able to figure out how to change the color of just a part of a number or a part of a particular date. 

thank you

3 Replies

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:

Martin_Weiss_0-1665479652868.png

Bild-303-005.png

@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

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)