Thread: Cell formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick Patrick is offline
external usenet poster
 
Posts: 160
Default Cell formatting

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