Results 1 to 2 of 2

Extract and Duplicate Based on Font Color

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    Toronto, Canada
    MS-Off Ver
    2007
    Posts
    2

    Extract and Duplicate Based on Font Color

    Hi everyone,

    I have a table, color coded the ingredients that I need to purchase in red. I'm looking to make a separate list with all the ingredients in red font. How can I do this? Below please see the table containing all the original data, and then below, the end result I'm looking for, in the smaller box with just the ingredients in red font.

    I tried filter by font color, it didn't work. I read somewhere that suggested VBA, but I'm too lazy to utilize VBA, so I'm looking for easier methods. If all else failed, can anyone teach me how to utilize VBA to get the end result I'm looking for quickly?

    Sort Font Color.png

    Thanks!
    Last edited by Lucy Zhang; 01-10-2015 at 03:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Table Extract based on Font
    By Aquamore in forum Excel General
    Replies: 2
    Last Post: 09-09-2014, 11:56 AM
  2. [SOLVED] extract and maintain font color
    By mqcai4613 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2013, 11:43 PM
  3. Change Font Color Based On Adjacent Cell Color
    By Zorro9758 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2013, 02:47 PM
  4. Replies: 2
    Last Post: 02-04-2013, 02:00 PM
  5. Change font color based on font color of another cell
    By Ibyers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 09:36 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