Macro for filters with exceptions?

**hiphopopotamus** · 01-20-2010, 05:21 AM

I am using Excel 2007. I have a list of 100 names all ranked from 1-100. Is there a way to create a macro that can filter out the top 20, a specific name and also any names with the cell colours blue and yellow?

At the moment using an advanced filter based on criteria I can filter out the top 20 and the specific name I want but can't work out how to leave the coloured rows in as well.

Thanks

**romperstomper** · 01-20-2010, 07:21 AM

I would recommend using an additional column that has a code for the coloured rows (or you can use a UDF or defined name to get the cell colour) and then include that in the filter criteria.