How to print without Conditional Formatting?
I have a sheet with a lot of conditional formatting that must be printed in the gantt view without any of the formatting. So each week I have to disable all the rules, print, and then enable them again. It's tedious. There must be a better way.
Any thoughts on how I can generate a gantt in a PDF without the rules and without the "disable / enable" routine?
I've tried many options but, to me, they seem like more work. "Saving as new" without the formatting isn't worth it. Reports carry the formatting over. Exporting to excel carries the formatting and loses the gantt chart...