I have a spreadsheet where some of the cells ar shaded through conditional formatting. The colors at the top of the page that doesnt have conditional formatting are printing in color. However the cells that have been shaded though the conditional formatting are not printing. They aren't gray scal either. Even in a print preview they are missing. Any advice as to why?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Spreadsheet not printing all Cell colors
0
Answers
0
Have you transferred your workbook between different Excel versions? You may like to read up on how conditional formatting is dealing with backward compatibility here.
I wonder if something similar might happen if your printer driver is outdated, perhaps because the printer itself is.
If none of this helps, could you post a redacted version of your workbook?
Discussion
I've never posted before. I don't see a way to attach the file. Do I need to resubit question with it attached?
mmcginnis (rep: 2) Jan 7, '20 at 8:57 am
You can Edit your question. Then, in Edit mode, you have access to a button "Add files" (or something like that) at the bottom of the screen. When you click that button you can browse to the file you want to attach. Note that only Excel files can be attached. Other formats aren't accepted.
Variatus (rep: 4889) Jan 7, '20 at 8:35 pm