Ability to sort data in Excel by fill color

O

okquiltluvr

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/com...dg=microsoft.public.excel.worksheet.functions
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DATEDIF FUNCTION NOT LISTED IN HELP 2
Select 'Sort By' column by simply typing heading letter 1
excel should have a rolling paste function 0
how to give hyperlink to hidden excel sheet 0
I Need a Tearoff Color Palette 7
counting unique text values in an array of data 1
pivottable bug 5
Search Function in Discussion Groups Home 0

Top