Hi:
When you are working with "excel" there are several different methods you could be using:
1) ODS CSV (create a comma separated file)
2) ODS HTML (and other HTML destinations) to create an HTML file that Excel can open
3) ODS TAGSETS.EXCELXP (a Spreadsheet Markup Language XML file) that conforms to the Microsoft specification for Workbook/Worksheet XML.
In ODS CSV, there would only be a TAGSET template involved in the creation of output. For the other 2 methods you could either be talking about needing STYLE template changes or TAGSET template changes. In my experience when talking about Excel, about 90-98% of what people need to do with templates usually involves changing a style template.
There is also a slight chance, that, given your procedure of choice that you might be changing a TABLE template.
When you look at your sample codes, do they start:
[pre]
proc template;
define style ....;
or
proc template
define tagset ...;
or
proc template;
define table...;
[/pre]
Without knowing what type of template you are dealing with, it is hard to help you. However, this paper is from last year's SAS Global Forum --
http://support.sas.com/resources/papers/proceedings09/227-2009.pdf
it is an overview of all 4 template types with some introductory basics on how templates operate. Perhaps that will put things in enough perspective that you can ask more detailed questions or possibly post some of the code.
Or, alternately, you might explain a bit more about what you want to do, such as
"I am creating a summary report of sales and I need to highlight the background color of the sales column to be yellow if the sales are under $500 and green if the sales are over $1000." or "I want to make a workbook with a worksheet for every BY group in my PROC PRINT." or ....perhaps elaborate a bit more on why you think a template change is required.
cynthia