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)