I used to have Excel 2003 and every other version before that. However, with
Excel 2007, all the standard colors have changed to some pretty horrible
colors and there is only about 10 standard colors.

How can I change the default color palette as my colors chosen don't become
new default colors, only the history of colors can I see but the default
colors don't change.

When I print, pink turns out clear, dark blue becomes light blue and just
generally my reports look like sh*t with Excel 2007 colors.

Any suggestions?