Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 542
Default How can I get excel to print mulitiple colors in a cell?

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.


--
James
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 109
Default How can I get excel to print mulitiple colors in a cell?

James wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200608/1

  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default How can I get excel to print mulitiple colors in a cell?

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

"James" wrote:

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.


--
James

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 542
Default How can I get excel to print mulitiple colors in a cell?

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.
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How can I get excel to print mulitiple colors in a cell?

James

Perhaps you have "Draft Quality" checked in Page SetupSheet


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 11:02:02 -0700, James
wrote:

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.




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 252
Default How can I get excel to print mulitiple colors in a cell?

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.

"James" wrote:

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.


--
James

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do the Excel cell colors only display in print preview? cajeot Excel Discussion (Misc queries) 1 May 24th 06 01:59 AM
Excel - print to .pdf using filename reference from cell scooppbear Excel Discussion (Misc queries) 1 May 17th 06 02:36 AM
Excel cell looks good in print preview but doesn't print??? Jack Gathright Excel Discussion (Misc queries) 1 September 13th 05 12:38 PM
How do I auto increment cell value on print in Excel Hiren Excel Worksheet Functions 7 January 25th 05 06:39 PM
EXCEL - Cannot print borders in color(s) I have selected Mark M Excel Discussion (Misc queries) 0 January 18th 05 03:25 PM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"