+ Reply to Thread
Results 1 to 4 of 4

Choose which colored cells to print and which to ignore

  1. #1
    Registered User
    Join Date
    09-02-2015
    Location
    Orange County, California
    MS-Off Ver
    2010
    Posts
    3

    Choose which colored cells to print and which to ignore

    I have a spreadsheet that I print-to-pdf and mail out to customers (a monthly statement). So I have it formatted with certain highlighted cells that make it look more professional and easier for the client to read. But I also have highlighted cells that make it clear to the employees here which cells need to be updated in the spreadsheet. But I don't want these particular cell colors to print. If I choose the black/white option in Page Setup, I lose the formatting highlights that I want to print. Is there a way to specify which cell colors to print and which cell colors to ignore when printing?

    Thanks for your help!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Choose which colored cells to print and which to ignore

    Maybe you can have notes down the right side of the file (outside the print area) which instruct your staff which cells on that row they should complete/update, then you don't need to highlight them within the printed area.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    09-02-2015
    Location
    Orange County, California
    MS-Off Ver
    2010
    Posts
    3

    Re: Choose which colored cells to print and which to ignore

    That's not a bad idea. Not ideal, but it will work for now. Thanks! @Pete_UK

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Choose which colored cells to print and which to ignore

    You're welcome - thanks for feeding back.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 11-29-2013, 10:27 AM
  2. Replies: 1
    Last Post: 11-09-2013, 02:43 AM
  3. choose what formatting to print the data
    By saraJ in forum Excel General
    Replies: 7
    Last Post: 06-28-2013, 06:15 PM
  4. Print to a specific Printer and also choose the pages to be printed.
    By aadeshgandhi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2013, 12:07 PM
  5. Replies: 4
    Last Post: 07-18-2012, 02:34 PM
  6. Have blocks of blue colored cells ... want them surrounded by lavender-colored cells
    By rocket1406 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-01-2007, 03:59 PM
  7. [SOLVED] How do I get the gridlines to print OVER colored cells?
    By JanetGU in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-16-2006, 04:55 PM
  8. How do you print gridlines in front of colored cells?
    By kirrwed in forum Excel General
    Replies: 1
    Last Post: 09-14-2005, 12:26 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1