locked
ListObject Table Styles RRS feed

  • Question

  • We have a need to create some ListObjects that may have a header row consisting of 2 rows.  So we want the header style to be applied to the top 2 rows instead of just the first.  It seems like it would be possible e.g. PivotTables accomplish this using similar objects, however the current object structure doesn't seem to allow this.  Is support for this likely to be added?

    Using Excel 2007, VS 2005 SE

    Thanks
    Chris
    Thursday, October 12, 2006 7:18 AM

Answers

  • While you can create custom table styles in Excel 2007, I dont think you can apply distinct "header style" to first 2 rows. However, you might consider using some conditional formatting which will  specify that if it the first 2 rows in the Table/ListObject it will be formatted in a certain way. That said, it might non-trivial express this requirement in a formula for conditional formatting.

    I hope this helps!

    Thanks,
    Nikhil

    Tuesday, November 7, 2006 1:23 AM