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).

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


On Tue, 23 Dec 2008 14:13:00 -0800, Rochelles
wrote:

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).

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

"Rochelles" wrote:

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).

Can I do this anywhere?

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.
--
David Biddulph

"Rochelles" wrote in message
...
Can I do this anywhere?