Can you filter or sort by a cell's formatting?

MalibuinthePeg · Jun 17, 2005

Can you filter or sort by the formatting of a cell - these were formatted
manually and do not have conditional formatting applied to them - thanks

Dave Peterson · Jun 17, 2005

You can even use a UserDefined Function that can return the colorindex.

Chip Pearson has a nice function at:
http://www.cpearson.com/excel/colors.htm

Returning The ColorIndex Of A Cell

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin · Jun 17, 2005

Hi

You can filter on color with EasyFilter Beta version 2.1
http://www.rondebruin.nl/easyfilter.htm