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

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

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

MalibuinthePeg wrote:

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

Hi

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dave Peterson" wrote in message ...
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

MalibuinthePeg wrote:

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