New features in conditional formatting extend to the object model as well. Excel has traditionally allowed users to access the formatting of their cells through the object model. For example, Users can use the interior class which lives off the range object to access the formatting of the cell. Selection.Interior.Color returns the background color of the cell. However, Selection.Interior.Color does not take into account the conditional formatting applied to the cell. In Excel 2010, we’ve introduced
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/08/13/the-dislpayformat-om.aspx
Posted
Aug 14 2009, 02:54 AM
by
Microsoft Excel