Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Oakland, CA, USA
    Posts
    161
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting (XL 2000)

    Hello, I have a question in regards to sorting a table in XL. One col - A - has names, the following cols have data. The cols that have data have a border around it and a fill color if the customer has been contacted. Now, if I sort the table by client/names the rest of the data is sorted right, just as it is supposed to. Also, the fill colors of the cell moves to where it is supposed to (with the correct client) BUT for some reason the borders of the cells DO NOT. Is that "normal" or should the border move with the sort. I hope I explained that so it can be understood. Any advise???? Thanks, Tira

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting (XL 2000)

    I duplicated your problem. Seems illogical to me that cell fill colors do get moved with the sort and borders don't. But this seems to be the thing to live with.

    A way to avoid this is to color and border the cells using a conditional format based on a value of another cell.

    - assume you enter a 1 in column D when a client has been contacted
    - select the column(s) that need to be formatted depending whether or not there is a 1 in column D
    - make sure the top-left cell is white (assuming this is a cell on row 2)
    - choose format, conditional formatting
    - in the lefthand dropdown select "Formula Is"
    - in the formula box type:
    =$D2=1 (change the 2 if you're not on row 2 with the active cell)
    - click the Format button and set all formatting for this condition
    - click OK.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Oakland, CA, USA
    Posts
    161
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting (XL 2000)

    Thanks, Jan, for your help. I will try it. Tira

Posting Permissions

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