We seem to have an issue with formatting performance in our excel product
when trying to format (color, font, # format) ranges.

If we loop through the ranges and dynamically define the formats it is a lot
slower than copying and pasting formats from say a template sheet.

Can anyone speak to this issue? For I would prefer to remove the template
sheet, then we would not need to keep a template excel workbook.
Any advice would be appreciated. Thanks in advance.

Regards,
Adam