| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can you filter or sort by a cell's formatting?
Can you sort by a group of cells by the color - were colored manually and do
not have conditional formatting applied to them. |
|
#2
|
|||
|
|||
|
Sorry for the short answer, but to the best of my knowledger there is no way. One work around would be to add a column and type a color code (b=blue, r=red) and then sort on that. -- yesac142 ------------------------------------------------------------------------ yesac142's Profile: http://www.excelforum.com/member.php...o&userid=24391 View this thread: http://www.excelforum.com/showthread...hreadid=380145 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| background formatting across multiple cells | Excel Discussion (Misc queries) | |||
| Cells losing formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
