Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

conditional format won't print in color

Posted by phillip on December 27, 2000 8:53 AM

I have a series of cells formatted in "conditional". If a particular value in the cell is out of range the cell font is displayed in red. When I print preview the page the display is in red. When I print the document the red font in the cell is printed in black. I am using Excell 2000 and Windows 2000 Professional and am sending to an HP Color Laserjet. Am I having a printer problem or is this some kind of Excel bug? Thanks

Re: conditional format won't print in color

Posted by Robert on December 27, 2000 9:03 AM

I just did a little test, same config, different HP printer (DJ 1120) and worked as expected...

Re: conditional format won't print in color

Posted by phillip on December 27, 2000 1:48 PM

Thanks for the comment. I have done some more testing and I only have this problem when I use legal paper in either landscape and/or portrait. When I use letter the color prints. I can replicate this same error using Word 2000 - ie. letter prints color but legal will not print color in either landscape or portrait. Very interesting ........

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.