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