+ Reply to Thread
Results 1 to 2 of 2

Cell colored, but not colored when printed?

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    293

    Cell colored, but not colored when printed?

    It there a way to make a cell a "color", but in a way the color does not print? (just the text / data, in the cell)

    Thanks

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,137

    Re: Cell colored, but not colored when printed?

    No. All cell formatting is sent to the printer and there are no options to suppress it.

    One workaround option is to create a "shadow" page with formulas that refer back to your other page but does not use cell fill colors, and print the shadow page.

    (P.S. I had to change your title slightly as a workaround to a bug in the forum software does funny things when the title ends in the word "print")
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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: 4
    Last Post: 01-19-2016, 10:24 PM
  2. Formula to add colored cell
    By rizmomin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-13-2015, 04:30 AM
  3. Replies: 1
    Last Post: 11-09-2013, 02:43 AM
  4. Colored Cell
    By krkrdibo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2013, 07:53 AM
  5. 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
  6. [SOLVED] How to check if a cell is colored?
    By prampuria in forum Excel General
    Replies: 2
    Last Post: 11-21-2005, 04:00 PM
  7. [SOLVED] SUMIF cell is colored
    By dtencza in forum Excel General
    Replies: 8
    Last Post: 08-18-2005, 01:05 PM

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