Yes, there is a way to apply printer settings to all pages in the workbook automatically. Here are the steps to do so:

1. Open the workbook that you want to set the print settings for.
2. Click on the "Page Layout" tab in the ribbon at the top of the screen.
3. Click on the small arrow in the bottom right corner of the "Page Setup" group to open the "Page Setup" dialog box.
4. In the "Page Setup" dialog box, click on the "Print" tab.
5. Under the "Print Quality" section, select the desired print quality and color options for your printer.
6. Click on the "OK" button to apply the changes to the current worksheet.
7. Now, to apply these settings to all worksheets in the workbook, right-click on any worksheet tab at the bottom of the screen.
8. Select "Select All Sheets" from the drop-down menu.
9. Repeat steps 2-6 to open the "Page Setup" dialog box and apply the print settings to all worksheets in the workbook.
10. Click on the "OK" button to save the changes.

Now, all worksheets in the workbook should have the same print settings applied, and you should be able to print the entire workbook in color without having to change the printer settings on each individual worksheet.