FILTER

  • Thread starter Thread starter vlook fomula
  • Start date Start date
V

vlook fomula

hI,

1. Is there any way to use filter on different color rows
2. Is there any ways to sort out rows with color wise

Regards
Zafar
 
If you're using xl2007, you can apply your data|filter and sort and filter by
color.

If you're using an earlier version (xl97-xl2003), you can use Ron de Bruin's
EasyFilter to filter by color.
http://www.rondebruin.nl/easyfilter.htm

If I wanted to sort by a color, I'd use a helper column to return the colorindex
that I wanted by using a user defined function like the one Chip Pearson shares.

Chip explains it here:
http://www.cpearson.com/Excel/SortByColor.aspx
 
In your above post, you didn’t mention which excel version you are using.

We can retrieve the Font Colour Data and Cell Colour data independently
while applying the Autofilter in Excel 2007. If the retrieving method is
based on a single column then it is very easier in Excel 2007 Auto filter.

If this post helps, Click Yes!
 
Hi,

i am using Excel 2003 and am tired can you help me please? for following
problem.
thanks
 
Have a good sleep then try again.

What part or parts of Dave's pointers to assistance do you not understand or
are having a problem with?


Gord Dibben MS Excel MVP
 
Back
Top