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) |