Export to Excel - Without the Colors

I am using Report Manager as my report interface. I am exporting Reporting Services reports with multiple colors to MS Excel (which has a very limited color palate).

When I export the reports to Excel, the system chooses the colors automatically, and I am not very happy with the colors selected. I would like to either control the colors in the export or make the exports black and white.

Does anyone have an idea how to do this?

The only way I know of how to do this is to edit the report in Report Designer (Visual Studio .net 2003) and make the desired color choices there and then deploy the report back to Report Manager.