info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Partial Text Color Change in Cell
113 views
Skip to first unread message
Rochelles
Dec 23, 2008, 5:13:00 PM12/23/08
to
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).
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
Dec 23, 2008, 5:21:33 PM12/23/08
to
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 95 64
Dec 23, 2008, 5:27:04 PM12/23/08
to
You can not change part of the cell format through conditional formatting.
Rochelles
Dec 23, 2008, 5:47:01 PM12/23/08
to
Can I do this anywhere?
David Biddulph
Dec 23, 2008, 6:11:59 PM12/23/08
to
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
Format/ Cells to change the font colour. You can't do that if the cell
contains a formula.
--
David Biddulph
"Rochelles" <roch...@discussions.microsoft.com> wrote in message
news:69BA94AC-2380-499D...@microsoft.com...
0 new messages