Forum Discussion
Printing a specified area without color!!
Hi All I want to print the below with Area 1 (Green Color) in "color" and area 2 (Blue Color) in "black and white", 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 font
My 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
