• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Partial Text Color Change in Cell - formula



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


Excel Ninja
Hi ,

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



Excel Ninja
Staff member
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