I
ichirus
Once was able to filter by color but option is no longer available on the
drop down menu
drop down menu
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
Such an ability isn't built in to Excel. If you did it in the past, it must
have been through some add-in or UDF.
have been through some add-in or UDF.
D
Dave Peterson
Are you using xl2007?
Maybe you used xl2007 at work/home and a previous version at home/work???
Or maybe you used Ron de Bruin's easyfilter addin?
http://www.rondebruin.nl/easyfilter.htm
Maybe you used xl2007 at work/home and a previous version at home/work???
Or maybe you used Ron de Bruin's easyfilter addin?
http://www.rondebruin.nl/easyfilter.htm
G
Gord Dibben
Excel 2007 has it built-in David.
Both sort by color and filter by color.
Gord
Both sort by color and filter by color.
Gord
D
David Biddulph
Well, that emphasises how much I've got to learn about 2007. Thanks for the
enlightenment, Gord.
enlightenment, Gord.
G
Gord Dibben
Takes a while.
Gord
Gord