If it says "Parts on Order", the background is yellow. The background colors, for example, if a cell in a certain column says "Repaired", the text is bold and the background is green. I have multiple tabs with conditional formatting that uses background colors to indicate various levels of importance, as well as text colors and/or Icon Sets. The problem is, I have a large (22mb) workbook created in Excel 2007. I have had multiple "experts" look into that issue for me.
I have never had so many problems upgrading to a new software version that breaks old functionality!)
(I have already spent hours and hours redoing conditional formatting rules because Excel 2016 refuses to work right when using cell color fills so I have to use bubbles instead. But in Excel 2016 they completely disappear! I confirmed that my Create PDF preferences have the "Add Links" box checked, both Excel 2016 and Acrobat are the latest versions.this is infuriating! These links allow navigation around the PDF from the Table of Contents and back via page headings. I have a large workbook that has hyperlinks (created with the "Insert Link" option in Excel, NOT the HYPERLINK formula) that I need to preserve when converting it to a PDFed report. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown.Ībout a year ago, when I was updating my company's reports, I received some assistance with this issue, so I'm hoping someone can help me again. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified
Post titles must be specific to your problem.
0 kommentar(er)
