Conditional format grey text prints black

[lunker55]

I have conditional formatted cells to turn text grey, but when I print, the
text is black.
How do I change this?

Joe

 

[Lukin]

Apologies in advance if I'm stating the obvious but have you checke
your printer settings? Have you tried formatting some other text i
grey (in Word for example) to see if that comes out black also?

There's also an option in Page setup to print in Black and White tha
could be the cause

 

[lunker55]

Everything looks right. I also conditional format the cell to grey as well,
and it prints correctly. It is just the text I format grey.
?????????
Joe

 

[Gord Dibben]

Joe

File>Page Setup>Sheet. Uncheck "black and white".

Gord Dibben Excel MVP

 

[lunker55]

Gord:
It is unchecked.

Joe

Joe

File>Page Setup>Sheet. Uncheck "black and white".

Gord Dibben Excel MVP

 

[David McRitchie]

Q320531 -- OFF: Changes to Fill Color and Fill Pattern Are Not Displayed,
Incorrect/missing colors may occur with use of High Contrast under Display tab of Accessibility Options. Colors don't show on
monitor however, you may be able to see the changes in print preview and on a printed page.
http://support.microsoft.com/?id=320531


1.. Click Start, click Control Panel, and then click Accessibility Options.
2.. Click the Display tab, and then click to clear the Use High Contrast check box.
3.. Click OK to close the Accessibility Options dialog box.