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
 
You can not change part of the cell format through conditional formatting.
 
You must log in or register to reply here.

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