Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort by Fill Color? (2003)

    Hi there! Does anyone know of a way to sort an excel spreadsheet by fill color? I have a document that has several line items that are color coded by status. What I'd like to do, for example, is see all of the line items that are red (which could be line items 1, 14, 40, 59) together by sort or filter. Any help would be appreciated!

    Thanks,
    Dory

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

    Re: Sort by Fill Color? (2003)

    You can use ASAP Utilities (free for non-commercial use), or use the functions from SortByColor on Chip Pearson's website.

  3. #3
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort by Fill Color? (2003)

    Hello Hans! Thanks very much for the super quick reply! I really appreciate your help! <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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