Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Eastern NC
    Posts
    1

    Red face Unanswered: Delete backfill color on print

    I have spreadsheets that have random cells with color to highlight specific trends of the report. When users of the report print it out, it makes it difficult to read from a b&w laser printer, but when viewing on screen it is great. Is there any way to make the backfill color not show up as shaded when you print?

    Any and all help would be greatly appreciated.

  2. #2
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: Delete backfill color on print

    Go to "Print Preview" > "Setup" > "Sheet" and check "Black & White" then save the file. All printers will print in black and white only, if your cell back colors are other than gray or black (i.e. Blue or green) the background color will not print.


    ----------
    Originally posted by starrman62
    I have spreadsheets that have random cells with color to highlight specific trends of the report. When users of the report print it out, it makes it difficult to read from a b&w laser printer, but when viewing on screen it is great. Is there any way to make the backfill color not show up as shaded when you print?

    Any and all help would be greatly appreciated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •