Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Microsoft Excel 2013: Cells with Conditional Formatting Linked to Powerpoint 2013

Status
Not open for further replies.

CrystalFacets

Technical User
Nov 3, 2016
28
US
I have Excel cells that include conditional formatting (icon set) in a 'helper' column. These cells are linked to a report that's in PowerPoint *using Paste Special >> Paste Link Microsoft Excel Worksheet Object).

It's been noticed that when converting the final report to a PDF before distributing, something unexpected occur depending on the way the PDF is created. FYI ... Folder containing files is attached (Excel doc, PPT and 2 ways of printing to PDF.

1) When using Print to File >> File Type=PDF, the conditional formatting background that was originally in a different color changes to white in the PDF.

2) When using Save as >> File Type=PDF, it's been noticed by others that the radio buttons used for conditional formatting appear to be slightly cut off on the right side. It's as if the cell width does not fit the radio button.​

Have others run into this issue? If so, are there fairly easy solutions? Thanks for advance for feedback.



 
 http://files.engineering.com/getfile.aspx?folder=33804056-6d9f-4f5c-9add-30e3acb8e531&file=Files.zip
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top