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!

Hi, welcome to the forum

You said that filtering by color did not work? What happened when you tried that?

Color is a format, not data, and excel formulas work on data, so there is no formula (that I know of) that will extract based on color. If there is some logic to how the color was applied, we may be able tpo use that to ID the rows to filter on.

Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.