How can I get excel to print mulitiple colors in a cell?

[Guest]

I have a simple page to print out but I want to format the text to print in 2
differnt colors (light gray and black). It looks good on the sheet but I can
not get it to print what I have formated as light gray in light gray. It
will only print the text as black? Even in print preview it changes it to all
black.

Is there a way to print 2 or more text colors in the same cell?

Thanks in advance for your help.

 

[Francois via OfficeKB.com]

I have a simple page to print out but I want to format the text to print in 2
differnt colors (light gray and black). It looks good on the sheet but I can
not get it to print what I have formated as light gray in light gray. It
will only print the text as black? Even in print preview it changes it to all
black.

Is there a way to print 2 or more text colors in the same cell?

Thanks in advance for your help.

If you highlight the words/ letters that you want to change colours in the
formula bar (near the top of the screen) then it should display and print OK

 

[Guest]

check that your print driver is not set for black and white printing. print
tpreview will convert ot black if it is.

 

[Guest]

Thanks for the replys.

I have the doc looking the way I want it when you view it on the computer.
When I switch to print preview it coverts all the numbers/text to black and
it prints how it looks in print preview. I have a header box that has a gray
shadeing in the backgound and that prints fine.

So my doc looks correct, but the print preview and the print itself is not
printing as it shows on the doc. Also I checked the driver and it is not set
to B&W.

 

[Gord Dibben]

James

Perhaps you have "Draft Quality" checked in Page Setup>Sheet


Gord Dibben MS Excel MVP

 

[Guest]

My computer does the same thing when I have my black and white printer
selected (HP Laserjet). It acts like it can only print monochrome. When I
change the text color it changes it to black when printing (whether I select
multiple colors or just one). If I shade the background it prints as black
dots instead of a shade of gray.

If I select my color printer (hp photosmart) it acts the way you and I would
expect it to.

So I think it is a printer setting but I can't find it.