| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ability to sort data in Excel by fill color
We often use fill colors to designate different values. It would be helpful
to be able to sort using these colors, to obtain value groups. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ability to sort data in Excel by fill color
hi
see this site for a short tutorial on how to do that. http://www.datapigtechnologies.com/f...rtonColor.html regards FSt1 "okquiltluvr" wrote: We often use fill colors to designate different values. It would be helpful to be able to sort using these colors, to obtain value groups. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ability to sort data in Excel by fill color
If you have Excel 2007 you can sort by cell color.
Earlier versions require adding a helper column or using VBA Gord Dibben MS Excel MVP On Tue, 18 May 2010 08:54:03 -0700, okquiltluvr wrote: We often use fill colors to designate different values. It would be helpful to be able to sort using these colors, to obtain value groups. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lost ability to sort by color | Excel Discussion (Misc queries) | |||
| I have lost the ability to fill color in excel cells, any hints? | Excel Discussion (Misc queries) | |||
| Can I sort excel spreadsheet data by fill color of cells? | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| How do I sort row data without row fill color moving as well? | Excel Worksheet Functions | |||
Hybrid Mode
