Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by Cell Color
Hello
How would I sort by the backgroun color of a cell? I want all same color cells to grouped to gether when I sort a range of cells. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by Cell Color
Excel has no sort by color functionality.
If the cells are colored due to Conditional Formatting, sort on the CF criterion(a) If manually colored see Chip Pearson's site for VBA function. http://www.cpearson.com/excel/SortByColor.htm Gord Dibben MS Excel MVP On Wed, 24 Dec 2008 16:28:01 -0800, da wrote: Hello How would I sort by the backgroun color of a cell? I want all same color cells to grouped to gether when I sort a range of cells. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by Cell Color
On Dec 24, 4:28*pm, da wrote:
Hello How would I sort by the backgroun color of a cell? I want all same color cells to grouped to gether when I sort a range of cells. Thanks Say Your data is in A2 Main Menu Type Name in the Workbook LColor And Then Refer to Type : =get.cell(38,A2) Add Ok Now type in B2 =Lcolor The Result show in Numbers Now sort Data AToZ Hardeep kanwar |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by Cell Color
Thanks for your reply, but I am confused. Can you please make it more clear?
Where do I write the workbook name? Where do I write the formula? Thanks "pai" wrote: On Dec 24, 4:28 pm, da wrote: Hello How would I sort by the backgroun color of a cell? I want all same color cells to grouped to gether when I sort a range of cells. Thanks Say Your data is in A2 Main Menu Type Name in the Workbook LColor And Then Refer to Type : =get.cell(38,A2) Add Ok Now type in B2 =Lcolor The Result show in Numbers Now sort Data AToZ Hardeep kanwar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible to sort the data by cell shading or cell color? | Excel Discussion (Misc queries) | |||
Excel should let me sort on cell background color | Setting up and Configuration of Excel | |||
Sort by Cell Color | Excel Discussion (Misc queries) | |||
how to sort according to the cell color? | Excel Discussion (Misc queries) | |||
Is it possible to sort and/or filter by cell shading color | Excel Discussion (Misc queries) |