Forum Discussion
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...
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)
text in B2
=SUBSTITUTE(B2,".","") but color will not display, it will display 11101987 after removing full stop
(11.10.1987)