Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting by color

    Hi,
    Is it possible to sort an Excel list by color - and, if so, how?

    Thanks.

    Wyley

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting by color

    You can convert the color of the font to a number using the following VBA function:

    Function ConvertColorToNumber(R As Range) As Integer
    ConvertColorToNumber = R.Font.ColorIndex
    End Function

    Add a column where you use this function to convert the color to a number and then select both columns and sort according to the column with the numbers.

Posting Permissions

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