+ Reply to Thread
Results 1 to 2 of 2

sort cells by font color

  1. #1
    Forum Contributor
    Join Date
    04-08-2008
    Posts
    121

    sort cells by font color

    Hi,

    Wondering if anyone can help. I've attached a sheet with 8 numbers in cells A1:A8 with blue and red fonts. I want to be able to sort these cells (A1:A8) by font colour (not value) and for the results to appear in Column B, when I press the button. I'm sure this is possible but not sure how.

    Any help would be much appreciated.

    Many Thanks
    Harry
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    Unless you have 2007 you will need to store information about the cells colour in a cell and sort that

    http://www.xldynamic.com/source/xld....r.html#sorting
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Font color conditional formatting
    By windme in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-05-2008, 02:21 PM
  2. Excel '02 Font Color Not Printing
    By The1nk in forum Excel General
    Replies: 5
    Last Post: 06-21-2008, 08:41 AM
  3. Changing font color to Red when 30 days passes
    By John Fletcher in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-30-2007, 08:53 PM
  4. Applying font color to part of text
    By ballack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2007, 01:44 AM
  5. Problem Linking Cells in Different Workbooks
    By jeffc4442 in forum Excel General
    Replies: 7
    Last Post: 02-23-2007, 11:01 AM

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