Ability to sort data in Excel by fill color

  • Thread starter Thread starter okquiltluvr
  • Start date Start date
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
 
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

Excel should let me sort by highlight color. 1
I Need a Tearoff Color Palette 14
DATEDIF FUNCTION NOT LISTED IN HELP 2
sort by highlite color 1
Excel should sort by month 3
how to give hyperlink to hidden excel sheet 0
make VLINKUP like vlookup; smart hyperlink by data value 3
Enable Excel to Sort by IP Address 0

Back
Top