Sort by Cell Color

  • Thread starter Thread starter da
  • Start date Start date
D

da

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
 
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
Click to expand...

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
 
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
 
Back
Top