https://communities.sas.com/t5/SAS-Procedures/color-formats-in-Excel-formats/m-p/21826#M4704 here is a quick example that shows how proc print can define color to be used in foreground, background and dynamic based on the value of the cell (although it is data cells for which dynamic background color is derived).[pre]ods _all_ close ;<BR /> ods tagsets.excelxp file='demo.xml'(title='test1') style= default ;<BR /> ods tagsets.excelxp options( sheet_name='col1' ) ;<BR /> proc format ;<BR /> value ages 0-9 ='gray'<BR /> 10-12='green'<BR /> 13-14='yellow' <BR /> 15-16='orange' other='white' ;<BR /> run;<BR /> proc print data= sashelp.class ;<BR /> id name /style(head)=[background=blue foreground = white] ;<BR /> var sex /style(head)=[ foreground = gray ] ;<BR /> var age /style(head)=[background=orange ]<BR /> style(data)=[font_weight=bold background=ages.] ;<BR /> run;<BR /> ods _all_ close ;<BR /> dm 'winexecfile "demo.xml" ' ;<BR /> ods listing ;[/pre]Hope you'll find it helpful. <BR /> For better guidance, look into the examples and notes for using ods tagsets.excelxp at <A href="http://support.sas.com/rnd/base/ods/odsmarkup/" target="_blank">http://support.sas.com/rnd/base/ods/odsmarkup/</A> .<BR /> <BR /> peterC sheet_name not sheetname was edited by: Peter.C Fri, 14 May 2010 12:34:07 GMT Peter_C 2010-05-14T12:34:07Z https://communities.sas.com/t5/SAS-Procedures/color-formats-in-Excel-formats/m-p/21825#M4703 i want to export files to excel with certain color formats on the headings.<BR /> <BR /> how can i do this? Fri, 14 May 2010 07:35:39 GMT https://communities.sas.com/t5/SAS-Procedures/color-formats-in-Excel-formats/m-p/21825#M4703 Jackie_Stanbank 2010-05-14T07:35:39Z https://communities.sas.com/t5/SAS-Procedures/color-formats-in-Excel-formats/m-p/21826#M4704 here is a quick example that shows how proc print can define color to be used in foreground, background and dynamic based on the value of the cell (although it is data cells for which dynamic background color is derived).[pre]ods _all_ close ;<BR /> ods tagsets.excelxp file='demo.xml'(title='test1') style= default ;<BR /> ods tagsets.excelxp options( sheet_name='col1' ) ;<BR /> proc format ;<BR /> value ages 0-9 ='gray'<BR /> 10-12='green'<BR /> 13-14='yellow' <BR /> 15-16='orange' other='white' ;<BR /> run;<BR /> proc print data= sashelp.class ;<BR /> id name /style(head)=[background=blue foreground = white] ;<BR /> var sex /style(head)=[ foreground = gray ] ;<BR /> var age /style(head)=[background=orange ]<BR /> style(data)=[font_weight=bold background=ages.] ;<BR /> run;<BR /> ods _all_ close ;<BR /> dm 'winexecfile "demo.xml" ' ;<BR /> ods listing ;[/pre]Hope you'll find it helpful. <BR /> For better guidance, look into the examples and notes for using ods tagsets.excelxp at <A href="http://support.sas.com/rnd/base/ods/odsmarkup/" target="_blank">http://support.sas.com/rnd/base/ods/odsmarkup/</A> .<BR /> <BR /> peterC sheet_name not sheetname was edited by: Peter.C Fri, 14 May 2010 12:34:07 GMT https://communities.sas.com/t5/SAS-Procedures/color-formats-in-Excel-formats/m-p/21826#M4704 Peter_C 2010-05-14T12:34:07Z