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

Guest · 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

Hold conditional formatting when sorting filtered data	1	Jul 6, 2009
Can you filter or sort by a cell's formatting?	1	Jun 17, 2005
Excel Conditional Formatting Removal	7	Apr 4, 2018
How to distinguish text color changes done by Conditional Formatti	4	Jun 4, 2008
Changing cell colors	1	Feb 11, 2010
Conditional Formatting	2	Sep 17, 2009
Counting the number of rows based on the color	2	Nov 3, 2009
Conditional formatting does not follow value when list is sorted	3	Dec 5, 2008

Ask a Question