Hi:
That formatting may change because of the way that Microsoft displays hyperlinks. I would assume that the hyperlink ability is the most important thing in the cell. So I would guess that the number gets plopped in the cell and then the hyperlink gets applied. I don't think that PROC REPORT is clobbering the style you set. I think that Excel is clobbering the style.
The reason I think it's Excel and not Proc Report is that if you run the program below, you will see that age and height columns are both Verdana 14pt when the file opens in Excel. When the height is over 69, the Verdana and 14pt are still in effect and only the foreground color changes to red.
[pre]
ods tagsets.excelxp file='c:\temp\class_style.xml' style=egdefault;
proc report data=sashelp.class nowd;
column name sex age height;
define name / order;
define sex / order;
define age / display style(column)={font_size=14pt font_face=Verdana} ;
define height / display style(column)={font_face=Verdana font_size=14pt};
compute height;
if height ge 69 then
call define (_col_,'style','style={foreground=red font_weight=bold}');
endcomp;
run;
ods tagsets.excelxp close;
[/pre]
You might investigate on the Microsoft site to see how they format hyperlinks by default. Or you might wish to work with Tech Support on this issue, but, I suspect that if it's an Excel issue there may not be a workaround from the SAS side of things.
cynthia