Hi there,
I have a spreadsheet with multiple sheets containing colour formatting
(including graphs) that is regularly printed out in colour and greyscale. The
problem I have is that when I need to print out several sheets simultaneously
I uncheck the "Greyscale" option under print options and have the print job
come out in colour. To print multiple selected sheets in colour I need to
change the print options for each individual sheet (about 10 in all) to
colour (non- greyscale). One strange peculiarity of this is that some of the
sheets will not need to be "Unchecked" whereas others will. They are not
necessarily the same sheets each time either.
Unfortunately due to page numbering I cannot print out each sheet one by one
either.
I have the reverse problem when I want to print in Draft in Greyscale.

Can someone help me? Is the colour status controlled by the sheet, the
workbook, or the printer? Can anyone suggest a solution?


Thanks for you help,