+ Reply to Thread
Results 1 to 4 of 4

Sort by color in Excel 2008 for Mac

  1. #1
    Registered User
    Join Date
    02-10-2009
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    58

    Sort by color in Excel 2008 for Mac

    Would very much appreciate a way to sort by color (either font or background)
    in 2008 for Mac. Every method I've found uses a VB module: which of course 2008 doesn't support.

    Thanks very much,

    Hook

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Sort by color in Excel 2008 for Mac

    Hello Hook,

    Welcome to the Forum!

    You will need to use AppleScript to write Excel routines in 2008. I don't know Apple script as I don't have a Mac. This article by Microsoft should give you a stating point.

    Using AppleScript with Excel
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    02-10-2009
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    58

    Re: Sort by color in Excel 2008 for Mac

    I appreciate your help Leith.

    I'll check out Apple Script and hope it's not too late
    to teach an old dog new tricks.

    I'm glad I found the forum. I'm sure I'll be back.

    Thanks again.

    Hook

  4. #4
    Registered User
    Join Date
    02-10-2009
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    58

    Unhappy Re: Sort by color in Excel 2008 for Mac

    Well, I just looked at Apple Script and it looks like Greek to me. Last time I did any type of programming it was in Fortran on punch cards.

    If it's not too much trouble, would anyone help an old man out and write me
    a script I can use?

    I really need it and I'd be very grateful.

    Hook

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1