Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting with formatting (XP)

    See attached sample, please. Shading sorts with the appropriate cell, but the diagonal line stays with whatever cell has that formatting? Is there a way around this?

    Thanks again

    Aunt Linda

  2. #2
    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: Sorting with formatting (XP)

    I don't think there is a way around it. The borders, even though they are properties of the range, are not always unique to the cell (though the diagonal is). A top border on a cell also adds the bottom border to the cell above.

    I presume the logic to how the borders would sort (is it the bottom to row 1 or the top of row 2 or is it both), was too much for the programmers so the borders objects are not included.

    The color and much of teh other formatting is unique to the cell (it does not affect any of the other cells) so this can be sorted without decisions on where the properly belongs

    Steve

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting with formatting (XP)

    I suspected as much - bummer! Thanks for the explanation.

    Aunt Linda

  4. #4
    Lounger
    Join Date
    Feb 2004
    Location
    Buffalo, New York, Wales
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting with formatting (XP)

    You could use the line tool to place a diagonal line in the cell(s). The line sorts with the cell as requested. See attached.



    yoyophil

  5. #5
    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: Sorting with formatting (XP)

    An excellent workaround <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

    Steve

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting with formatting (XP)

    GREAT IDEA - thank you soooooo much.

    Aunt Linda

Posting Permissions

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