Highlight all the rows with sales from to million. A color palette appears, from which you may choose a color by clicking its thumbnail. For our example, we've chosen Yellow from the Standard Colors group. From 60 to 65 million, choose green; for 50 million, choose Orange; choose lavender for 40 to 45 million, and cyan turquoise from 30 to 39 million.
Choose a sort key from the Sort By field box under Column , such as Author. Select all rows that don't contain the colors, right-click on any of them and select "Hide. Kirk Bennet started writing for websites and online publications in He covers topics in nutrition, health, gardening, home improvement and information technology.
Skip to main content.
Launch Microsoft Excel and open the spreadsheet you want to filter by multiple colors. Click the "Data" tab at the top of the Excel window. Click the arrowhead, select "Sort by color" and click "Custom Sort. Select the column in the Sort By drop-down box.
Select "Font Color" in the Sort On drop-down box. Click "Copy Level" at the top of the Sort window to duplicate the filter.
In this case, you can use the sort function to sort the data by color quickly as follows:. Bring tabbed editing and browsing to Office include Excel , much more powerful than the browser's tabs. Free Download Then click Sort by drop down list, select the data that you sort, and then click Values drop down list, chose Cell color , then click no cell color drop down list, select the color you would like on top.
Click Add Level to add additional lines to specify the order of the remaining colors. See screenshot:. Tip: Other languages are Google-Translated.
You can visit the English version of this link. Log in.
Forgot your password? Forgot your username?
Kevin says:. How to Alphabetize in Excel To alphabetize in Excel, highlight a cell in the column you want to sort by. You can sort by several columns by adding levels of sorting criteria. Its really awesome article, I have got much clear idea on the topic of from this article. Indeed helpful.