https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-cell-border/m-p/64792#M7556 Okay, I found the answer by reading the tagset source code.<BR /> FYI style(column) {borderrightcolor=#xxxxxx borderrightwidth=3 borderbottomcolor=#CCCCCC borderbottomwidth=1}<BR /> <BR /> gave me the vertical line. Thu, 04 Mar 2010 20:20:16 GMT Flip 2010-03-04T20:20:16Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-cell-border/m-p/64791#M7555 I have programmed an excel sheet using ODS excelxp that has accross groupings. Everything works well, but I would like to put a dark border on one column per group to separate the fiscal year groupings.<BR /> <BR /> I can change the background color of this column, but I cannot find the correct keywords to control the border. I can change the thickness of all the borders, but I would like to set just the right border to black.<BR /> <BR /> The column definition is like :<BR /> DEFINE lift / SUM FORMAT=5.2 ... style(column)={background=#B6DDE8};<BR /> This sets the color just fine, but I cannot find the key words for the border. If anyone knows where the allowable keywords for styles, that would help as well.<BR /> <BR /> Or am I stuck with having to define a style before hand and just reference it? Thu, 04 Mar 2010 17:50:10 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-cell-border/m-p/64791#M7555 Flip 2010-03-04T17:50:10Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-cell-border/m-p/64792#M7556 Okay, I found the answer by reading the tagset source code.<BR /> FYI style(column) {borderrightcolor=#xxxxxx borderrightwidth=3 borderbottomcolor=#CCCCCC borderbottomwidth=1}<BR /> <BR /> gave me the vertical line. Thu, 04 Mar 2010 20:20:16 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-cell-border/m-p/64792#M7556 Flip 2010-03-04T20:20:16Z