Printing issues with icon conditional formatting in Excel

Anonymous
2015-02-24T15:19:23+00:00

I have an Excel file containing conditional formatting using icons (red/yellow/green buttons and up/down arrows).  Everything looks great on screen and in print preview, but when I actually print (either to pdf or paper) the icons have a white background around them.  The white is not for the entire cell, but just around the icon.  For example, a red button icon looks like a red circle overlayed on a white square.  How can I fix this so it prints as it is displayed?  I've tried all combinations of print settings that I know to try (high quality, press quality, etc).  Here's a partial screenshot of the pdf print:

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

5 answers

Sort by: Newest
  1. Anonymous
    2017-01-27T09:08:06+00:00

    I had the same issue, and I found out what it was. My worksheet was set to print in black and white only. In my version of Excel you find this here:

    File > Print > Page Setup > Sheet > Uncheck "Black and White"

    When I unchecked that the icons printed and displayed in print preview just fine.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2015-02-27T01:46:20+00:00

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2015-02-25T21:44:26+00:00

    Upload your workbook to one of the file-sharing sites then post the address(url) here.

    https://www.dropbox.com/       is a popular site.

    Gord

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-02-25T18:24:00+00:00

    When I take a screenshot, it looks great.  In fact, that's been my workaround thus far.  Print preview looks good to.  It's when we actually print that the white background shows up. 

    As our processes mature though, the sheet is growing (in rows) so screenshots will be less efficient.  Also, we want an easy way for our users to be able to print.  Right now, either printing to paper or pdf causes the issue.  Here's a screen capture and how I want the actual print to look:

    Let me know the best way to share the file I am working with.  I didn't see a way to attach it to this post.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2015-02-24T16:22:51+00:00

    Can you share the file... just the cells with the issue... you may remove all other data.

    I just tried to print to PDF and got the following;

    I am using Excel 2013... I have not heard of this problem before...

    Try to take a screen shot of the cell, paste it into a new sheet and print... what happens?

    Was this answer helpful?

    0 comments No comments