Why is my printer printing white fonts as black?

[Howie]

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)

 

[dominicb]

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]

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