Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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? – Meehow 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

Follow these steps:

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

    Print Preview shown in 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 shown in Black & White

share|improve this answer
There is no Printer properties option under Print in excel 2007. You need to say what to do in this circumstance. – user489465 Aug 28 '15 at 7:06

Your Answer


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.