Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I would like to print my filled cells in a different color to match the rest of my document. The filled cells contain green background and blue font. I want the cells to automatically print to grey background and black font. I do not want to have to go through my document and manually change the font and shading.

Is it possible to print the file as grayscale? Or, could someone provide me with a macro or code that would solve this problem?

share|improve this question
2  
What happens if you print using grey scale? –  Dave Aug 27 '13 at 13:24
    
you could have a macro that would toggle the fill before and after printing. Is this something you would consider a solution? –  vba4all Aug 27 '13 at 13:44
    
I want the document to always show the green shade and blue font. I want the print version to always show the grey fill and the black font. I would consider anything that would allow me to do this. –  user248913 Aug 27 '13 at 14:20
    
Have you tried conditional formatting? –  James Jenkins Aug 27 '13 at 17:29
    
I have. The problem with conditional formatting is the cells will change from the green color to the grey color and stay that way after text is inserted. I want the input cells to always be green and just grey when they are printed. –  user248913 Aug 27 '13 at 17:59

1 Answer 1

Follow these steps:

  1. Select your print and then click on Printer Properties. (Right now, you can see the priview shows our sheet in color).

    Print Preview - Color

  2. In Paper/Quality Tab, change the Color Setting to Black & White.

    Printer Properties

  3. As you can see, the preview turns to Grayscale and the sheet would print out in Gray background and black font.

    Print Preview - Black & White

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.