Partial Text Color Change in Cell - formula

[madocar]

Hello,

please is it even possible to color only a part of text in a cell by formula?

Let's say in a cell A1 is a text = partial text

==> partial(red color) text(green color)

Thanks for any answer

 

[NARAYANK991]

Hi ,

A formula cannot alter the color of a cell or its contents , leave alone a part of its contents. VBA can.

Narayan

 

[madocar]

Thanks Narayan
I Thought so.
Condititional formatting won't help as well right?

 

[NARAYANK991]

Hi ,

CF can colour a cell or its contents , but I doubt if it can colour partial contents.

Narayan

 

[Hui]

CF cannot partially change a cell's text color
That can only be achieved by using VBA

It is not overly difficult provided you have a good set of rules as to define what is to be changed and when

 

[Villalobos]

Hello,

please is it even possible to color only a part of text in a cell by formula?

Let's say in a cell A1 is a text = partial text

==> partial(red color) text(green color)

Thanks for any answer

If VBA allowed then here is an approach.