How do I get print preview to deslpay & print the color text.

[dmorlando]

I have a worksheet with both color and B/W text on it, but when I go into
print preview mode it shows up as black and white only. In addition it prints
in black and white even when I have the printer set to "print color".

I looked all over for some type of format setting and I searched the help
data bases, but could not find a thing.

Please help me.
Thanks.

 

[Gord Dibben]

If you are set to print in color and don't have Black and White checkmarked
perhaps that setting is being overridden by having "Draft Quality"
checkmarked.

File>Page Setup>Sheet..............uncheck it there.


Gord Dibben MS Excel MVP

 

[dmorlando]

Black&White is not selected.

Hi
Goto> File> Page Setup > Sheet tab and unselect Black&White
HTH
John

 

[dmorlando]

Draft Quality is not selected either

If you are set to print in color and don't have Black and White checkmarked
perhaps that setting is being overridden by having "Draft Quality"
checkmarked.

File>Page Setup>Sheet..............uncheck it there.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

You have pretty well excluded any Excel setting as the source of your
problem.

Look to your printer.

Does it print color in other applications?


Gord