I have a number of documents I use conditional formatting color scales or highlighting on to help with error checking, and data flow. However, I have a black and white printer in my office. Right now, I usually print in grayscale, and most of the time, the data is readable, however sometimes its not, and I waste time checking for readability.
I can use icon sets instead of highlighting cells with color, but it still leaves me with the color coding on the spreadsheet that is strictly for data flow (For instance, yellow cells are for time entry, orange cells are calculated by formula) The spreadsheets are shared and the colors are standard throughout the worksheets I write to help prevent broken spreadsheets.
Ideally though, I'd like a way to set excel to print the worksheet in black and white. I've already selected the setting that prints all text as black. Any ideas?
I'd like to avoid writing a script that would clear the formatting, print the sheet, and replace the formatting, though I can if there isn't a more elegant solution.
I can use icon sets instead of highlighting cells with color, but it still leaves me with the color coding on the spreadsheet that is strictly for data flow (For instance, yellow cells are for time entry, orange cells are calculated by formula) The spreadsheets are shared and the colors are standard throughout the worksheets I write to help prevent broken spreadsheets.
Ideally though, I'd like a way to set excel to print the worksheet in black and white. I've already selected the setting that prints all text as black. Any ideas?
I'd like to avoid writing a script that would clear the formatting, print the sheet, and replace the formatting, though I can if there isn't a more elegant solution.
