This worked yesterday morning and then I applied some MS updates. That's when it started acting funny.
I am using MS Office Excel 2007 (12.0.6550.500) SP2 MSO(12.6554.5001) running on Window XP Professional Professional 2002 SP 3.
SAS Information Delivery Portal 4.2
SAS Server 9.2 running in the Stored Process Server (TS2M3)
In prior versions of Office, I think that you only have a palette of 56 colors with Excel (like 2000, 2003 and even 2007). It's not until Excel 2010 that you have all 16.7 million colors. So that means browsers will show more "accurate" colors than earlier versions of Excel. For example -- a color that is defined in hex as #6495ED (light blue) will show as blue in the browser, but is mapped to a more purple/lavender color in Excel 2003 and 2007.
Tanks for reconfirming my results of all data in blue. I'll readup on the paper you discussed from SGF2011 and excelxp. I hope it gives the users a way to dowload from html to excel.
It's odd that those colors work for col_color_even="lightyellow" & col_color_odd="palegoldenrod", but when I comment those two lines out and uncomment banner_color_even="lightyellow" & banner_color_odd="palegoldenrod" it doesn't work. So I tried banner_color_even="#FFFF99" & banner_color_odd="#FFFFCC" (color 20 & 36) and everything still comes out in blue like it did for Andre. So I just tried it with yellow and green and still got all blue.
In fact the header background works with lightyellow - HEADER_bgcolor="lightyellow"!!!! And this all worked two days ago...