fill color not displaying in preview or print
 

I have a datafiltered spreadsheet with 2 columns that have a fill color
applied - yet when i print the spreadsheet the 2 colored columns STILL print
in b&w w/o the fill color ... In fact, the ONLY way I can see the fill color
is in print layout view ... why can't i see the fill color in print preview
AND, more importantly, why doesn't the fill color show up on my print?

fill color not displaying in preview or print
 

Hi RJ
Have you checked your printer settings. Make sure your printer is set to
colour.
They sometimes default to B&W.

And the obvious question, is it a colour printer.

HTH
Michael M

"RJ" wrote:

I have a datafiltered spreadsheet with 2 columns that have a fill color
applied - yet when i print the spreadsheet the 2 colored columns STILL print
in b&w w/o the fill color ... In fact, the ONLY way I can see the fill color
is in print layout view ... why can't i see the fill color in print preview
AND, more importantly, why doesn't the fill color show up on my print?

fill color not displaying in preview or print
 

Yes - however this is a worksheet that's on a network shared drive - moreover
you can only see the fill color in page layout, but not in print preview ...
and someone else can view and print the worksheet with the color just not me
.... is there a preference (in sharing) that might need to be
checked/unchecked?

"Michael M" wrote:

Hi RJ
Have you checked your printer settings. Make sure your printer is set to
colour.
They sometimes default to B&W.

And the obvious question, is it a colour printer.

HTH
Michael M

"RJ" wrote:

I have a datafiltered spreadsheet with 2 columns that have a fill color
applied - yet when i print the spreadsheet the 2 colored columns STILL print
in b&w w/o the fill color ... In fact, the ONLY way I can see the fill color
is in print layout view ... why can't i see the fill color in print preview
AND, more importantly, why doesn't the fill color show up on my print?

fill color not displaying in preview or print
 

See if this helps:

http://support.microsoft.com/?id=833258

--
Biff
Microsoft Excel MVP


"RJ" wrote in message
...
I have a datafiltered spreadsheet with 2 columns that have a fill color
applied - yet when i print the spreadsheet the 2 colored columns STILL
print
in b&w w/o the fill color ... In fact, the ONLY way I can see the fill
color
is in print layout view ... why can't i see the fill color in print
preview
AND, more importantly, why doesn't the fill color show up on my print?

fill color not displaying in preview or print
 

Biff

OP's problem is the other way round.

Can see the colors on the sheet but not in Preview or when printed.


Gord

On Thu, 3 Jan 2008 17:24:40 -0500, "T. Valko" wrote:

See if this helps:

http://support.microsoft.com/?id=833258

fill color not displaying in preview or print
 

Check your Page SetUpSheet settings.

Uncheck Black and White and Draft Quality.


Gord Dibben MS Excel MVP

On Thu, 3 Jan 2008 13:56:00 -0800, RJ wrote:

I have a datafiltered spreadsheet with 2 columns that have a fill color
applied - yet when i print the spreadsheet the 2 colored columns STILL print
in b&w w/o the fill color ... In fact, the ONLY way I can see the fill color
is in print layout view ... why can't i see the fill color in print preview
AND, more importantly, why doesn't the fill color show up on my print?

fill color not displaying in preview or print
 

Exactly Gord - I suspect this is a sharing issue .... everything about the
document says color allowed, so it has nothing to do with viewing colors ....
I suspect it's a sharing preference that has somehow disallowed me from
viewing or printing the document fully (with highlight/fill color
displayed/printed).

"Gord Dibben" wrote:

Biff

OP's problem is the other way round.

Can see the colors on the sheet but not in Preview or when printed.


Gord

On Thu, 3 Jan 2008 17:24:40 -0500, "T. Valko" wrote:

See if this helps:

http://support.microsoft.com/?id=833258