Is it possible to use the ExcelServices web service to format a cell or a range??? Modifying the data works great now, but I'm not seeing much on working out colors, borders, etc.© 2009 Microsoft Corporation. All rights reserved.Thu, 09 Jul 2009 08:52:46 Z27a918ef-ff23-4959-87d2-437fdecb7d6dhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/27a918ef-ff23-4959-87d2-437fdecb7d6d#27a918ef-ff23-4959-87d2-437fdecb7d6dhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/27a918ef-ff23-4959-87d2-437fdecb7d6d#27a918ef-ff23-4959-87d2-437fdecb7d6dmooserzhttp://social.msdn.microsoft.com/Profile/en-US/?user=mooserzIs it possible to use the ExcelServices web service to format a cell or a range??? Modifying the data works great now, but I'm not seeing much on working out colors, borders, etc.Mon, 29 Jun 2009 20:15:56 Z2009-06-30T06:41:57Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/27a918ef-ff23-4959-87d2-437fdecb7d6d#17b5a672-ae58-4ad1-af70-e47519df3d89http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/27a918ef-ff23-4959-87d2-437fdecb7d6d#17b5a672-ae58-4ad1-af70-e47519df3d89Serge Luca [MVP]http://social.msdn.microsoft.com/Profile/en-US/?user=Serge%20Luca%20%5bMVP%5dI don't see any way to do this withe the Excel Services API, but you can modify the spreadsheet by using the <a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=C6E744E5-36E9-45F5-8D8C-331DF206E0D0&amp;displaylang=en">OpenXml sdk 2.0</a>   and re-publish it<br/> <br/><hr class="sig">Serge Luca; blog: http://www.redwood.be Fri, 03 Jul 2009 08:53:59 Z2009-07-03T08:53:59Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/27a918ef-ff23-4959-87d2-437fdecb7d6d#80040cd4-5426-4891-8746-a1a9ce83ea22http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/27a918ef-ff23-4959-87d2-437fdecb7d6d#80040cd4-5426-4891-8746-a1a9ce83ea22Shahar Prish - MSFThttp://social.msdn.microsoft.com/Profile/en-US/?user=Shahar%20Prish%20-%20MSFTThere is no direct way of doing that.<br/><br/>That said, you can use conditional formatting based on another cell to do this - it will be quite annoying and will not be realistic for complex formatting, but there you have it.<hr class="sig">Shahar Prish Blog: http://blogs.msdn.com/CumGranoSalis Professional Excel Services: http://www.amazon.com/Professional-Excel-Services-Programmer/dp/0470104864Tue, 07 Jul 2009 22:49:15 Z2009-07-07T22:49:15Z