Multiple text colours in a single cell

R

Ron

Can I have multiple colors in a single cell? I have text numbers that I
require to have various colours in a single cell.
eg. 123456 where the 4 is to be red and the 6 green with the remaining 1235
in black
 
D

Dave Peterson

As long as the cell is really text (preformatted as text or data entered as:
'123456), you can select the characters to make red in the formula bar, then
click on Format|cells and change the color.

(that's xl2003 menus)
 

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

Tracked changes by multiple people modified to one 0
Excel does not accept text format! 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
How to link seperated documnet into a single document 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Change the colour of a neighbouring cell 6
Bracers before text in a single cell 1

Top