Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting Outlining rows (2000)

    Using Data/Subtotals I want the sub-total rows to formatted a certain way - bold for example. Apparently I can amend the ColLevel Style and RowLevel Styles using Format/ Styles, and these should then be used.. but it doesn't work!! Any ideas how I can get this to work?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting Outlining rows (2000)

    I have never heard of RowLevel and ColLevel styles in Excel, can't find anything about them in Google either. Perhaps you can use conditional formatting. In the attached workbook, I selected A2:C22 and set conditional formatting, with Formula Is and the following formula:

    =OR(RIGHT($A2,5)="Total",RIGHT($B2,5)="Total")

    The column references are absolute, and the row references relative, so that the formula will be adjusted the correct way for the other cells in the selected range.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Outlining rows (2000)

    Thank you, I can see that would work. I would hope to use the in-built system, however, rather than complicated cond.formatting.
    Apparently, Format/Style has styles called ColLevel1, RowLevel1, and RowLevel2 which can be applied (from Data/Group and Outline/Settings) to the Outlining feature. Anyone manage to get this to work?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting Outlining rows (2000)

    In Excel 2002, the styles are named RowLevel_1 (for the grand total), RowLevel_2 (for the first level) etc. Note the underscore in the name. Editing these styles is reflected in the subtotal rows. Thanks for making me aware of this, I had never noticed it.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Outlining rows (2000)

    Yes but.. it doesn't seem to work.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting Outlining rows (2000)

    What happens if you try to modify the styles RowLevel_1 etc. in the attached workbook?

  7. #7
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Formatting Outlining rows (2000)

    I don't have an automated solution but if you collapse the outline, you can then select the range, hit F5, GOTO Special, select Visible Cells Only. Then format those cells only. Crude but it does work.

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formatting Outlining rows (2000)

    Formatting the style works for me in the file in XL97

    Steve

  9. #9
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formatting Outlining rows (2000)

    Andrew,
    Did you get Zeno's solution. I do this all the time and it works pretty well for me!!!
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •