Partial Text Color Change in Cell

[Rochelles]

Is it possible to change the color of just one number or word in a formula? I
have been reading and trying some of these conditional formatting posts, but
so far, no luck for what I am trying to do... For instance: =132+130+58 (and
I only want 130 to be red and the rest black).

 

[Gord Dibben]

Cannot do this with CF or within a formula.

You must paste the formula as value then edit just the number you want to be
red.


Gord Dibben MS Excel MVP

 

[Sheeloo]

You can not change part of the cell format through conditional formatting.

 

[Rochelles]

Can I do this anywhere?

 

[David Biddulph]

If you have text in the cell, you can highlight part of that text and use
Format/ Cells to change the font colour. You can't do that if the cell
contains a formula.