Forum Discussion
Printing a specified area without color!!
7 Replies
Sameer_Kuppanath_Sultan Hi Sameer, if you want to print all of this on one sheet, then change the background and font color and take the print, but if you want to take the print of specific area like green color etc. Then first select that area you want to take a print and -under the page layout tab in home ribbon- click on print area- now in print area dropdown button click on - set print area - now check the print preview - to know if you got the one you want.
I need to take whole the report in both black and white color, is it possible?
I think you'd need to add a conditional formatting switch
So in A1 type the word "Print View?", in B1 Type Yes
Then highlight your blue cells and go to Home > Conditional Formatting > New Rule > Using a formula =$B$1="Yes" and chose a Black or White background with White or Black fontMy suggestion was to toggle the setting prior to clicking print.
Potentially you could use a Macro to automate it changing, printing, changing back
I can't see how else it would be possible
