| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you filter or sort by a cell's formatting? | Excel Discussion (Misc queries) | |||
| Filter and sort | Excel Discussion (Misc queries) | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| Cells losing formatting | Excel Discussion (Misc queries) | |||
Linear Mode
