lost ability to sort by color

[ichirus]

Once was able to filter by color but option is no longer available on the
drop down menu

 

[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

 

[Gord Dibben]

Excel 2007 has it built-in David.

Both sort by color and filter by color.


Gord

 

[Gord Dibben]

Takes a while.

Gord