I believe formatting individual characters only works for text....not numbers.

Maybe try this?:
Format the cells as Text.
Then right-align them and change the individual character colors.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Patrick" wrote:

A new challenge for me!

I am entering different numbers in the same cell. I need the numbers to be
a different color. Is it possible to have Excel do this? I have tried
conditional formatting but I have a problem. If, for example, I want the
number 1 to be red it will be red if it is the ONLY number in the cell. As
soon as another number is entered, both are are the default color.

I am hoping I can do this without putting everything in it's own separate
cell.

Thanks in advance