| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by Cell Color
Hi,
Can anyone let me know if I can sort a column by the color of the cell? tks, steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by Cell Color
The short answer is no, there is no standard function in Excel to do
that.......the long answer is YES, if you really want to do that, you can get there using some of Chip Pearson's clever techniques..........see here http://www.cpearson.com/excel/SortByColor.htm Vaya con Dios, Chuck, CABGx3 "sjs" wrote: Hi, Can anyone let me know if I can sort a column by the color of the cell? tks, steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by Cell Color
You may want to check Chip Pearson's site:
http://www.cpearson.com/excel/SortByColor.htm sjs wrote: Hi, Can anyone let me know if I can sort a column by the color of the cell? tks, steve -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort or sub-total by Fill color or font color | Excel Discussion (Misc queries) | |||
| COMMAND BUTTONS and CELL COLOR | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Color a cell and a value is automatically assigned to that color. | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Hybrid Mode
