Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2005

Tip: Looking for answers? Try searching our database.

Why is my printer printing white fonts as black?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Howie - 24 Nov 2005 20:26 GMT
Hi all. Hope you can help.

I have a sheet which has conditional formatting which sets all
zero values to white fonts.

However, although the sheet effectively shows a blank cell in all
zero cells (or more accurately, white-on-white), my printer
insists on printing these cells in black - as if the font is not
set as white at all.

Any ideas?   thanks.

(Excel 2003)

Signature

Howard Coakley
e-mail...    howard<dot}coakleyatcoakley<dot].codotuk
Skype ID: howie10 (get skype from www.skype.com)

dominicb - 24 Nov 2005 21:14 GMT
Good evening Howie

You've almost answered your own question here:

"my printer insists on printing these cells in black - as if the fon
is not set as white at all."

Conditional formatting just makes your cells "look" a different colou
to you - to the computer there is no difference.  If you manually se
your text to white on white, then XL will recognise it as such, but n
so with conditional formatting.

Additionally, if you try using a macro to determine the colour of
conditionally formatted cell, it will not return the colour index o
the colour that YOU see.

Kind of difficult to explain, but hope that settles it.

HTH

Dominic
Gord Dibben - 24 Nov 2005 21:33 GMT
Howie

I'm guessing that File>Page setup>Sheet  "black and white" is checked.
Uncheck it.

White is a color and needs to print in color.

Gord Dibben Excel MVP

>Hi all. Hope you can help.
>
[quoted text clipped - 9 lines]
>
>(Excel 2003)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.