Hi,

I have a question about spreadsheets in Excel. I need to be able to export
data from SQL server into two workbooks in an excel spreadsheet. I have this
working fine, but I now need to format the data to make it look prettier.
This mainly consists of colouring certain rows depending on their location
within the spreadsheet report, and possibly adding some expanding and
contracting regions to some areas of the report.. What would be the best way
to accomplish this? Would it be as part of the report generation, or would I
be better off having some code that runs on the spreadsheet the first time
it's opened that parses through the data and applies the formatting?

Regards,

Tim.