Partial Text Color Change in Cell

  • Thread starter Thread starter Rochelles
  • Start date Start date
R

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Color of cell 3
Changing cell colors 1
Excel Macro to automatically go to the right of the last colored cell 0
Change Text Color in one cell based upon entry in referenced cell 3
How to filter rows data based on background color of individual cells 1
Partial Shading in Excel 2003 4
Changing the color of a cell based on the color of another cell. 6
Font color change if cell if null 2

Back
Top