Automatically print 1 copy in colors and 1 copy in black&white

In Microsoft Excel I wish to automatically print 1 copy of the document in colors and 1 copy of the document in black&white.

Is there a way to do it in 1 step instead of these 2 steps I do now:

  1. CTRL+P -> ENTER (for the color copy)
  2. CTRL+P -> CHANGE TO THE B&W PRINTER -> ENTER (for the black&white copy)

Your help would be highly appreciated as we do this operation hundreds of times every day :)
 
Back