Can Excel Sort by Color? How to Fill Color and use Sort & Filter’s Custom Sort - cyruspreges

Put up Excel sort by color? Absolutely. In addition to categorization by values, Excel can sort aside cell color, font color, and cellular telephone icon.

First off, you must you mustiness define the colors for your sort columns/fields. For this case, we'll prize colors based happening the SALES column.

1. Foreground all the rows with sales from 100 to 500 million. To choose a background color, clickHome connected the main menu row and go to theFont group. Uncovering the paint-bucket icon that stands forFill in Tinge, and click the push down arrow next to it. A color pallette appears, from which you may choose a colorise by clicking its thumbnail. For our example, we've chosen Yellow from the Standard Colors group.

2. Highlight the next group with sales from 77 to 85 jillio, then choose Dingy.

3. From 60 to 65 million, select green; for 50 million, choose Orange; pick out lavender for 40 to 45 meg, and blue-green (turquoise) from 30 to 39 million

01 choose colors for each specific range — Choose colors for each specific range

Now that the colors are defined by Gross sales, you fanny use them to sort aside BOOK, AUTHOR, Linguistic process, or Pothouse DATE, and, for example, take i authors with sales of Teal, which denotes the radical with sales between 30 and 39 million.

1. Move the cursor anyplace inside the data range, press Ctrl+A to highlight everything.

2. From the Location tab on the main menu, blue-ribbon the Editing radical. ClickSort out & Filter > Custom Sieve and the Sort dialogue box opens.

3. If you throw headers, equal sure to check the box that says: My data has headers.

4. Choose a sort key from the Sort Aside field box under Column, so much as Author.

5. Below Sort On, choose Cell Color from the drop-down leaning.

6. Under Order, choose the thumbnail for the color by which you wish to screen—in our exemplar, it's chromatic.

7. And, in the last field boxful, pick out On Top, which sorts the selected rows to the top of the spreadsheet (choosing Along Inferior sorts the selected rows to the tush).

8. Next, get across the Add Level push, which adds a bit kind key to the query.

9. From left to right, choose Writer, Cell Values, A to Z, and click OK.

02 sort spreadsheet range by color first then by author — Screen out spreadsheet range aside color first, then by AUTHOR

Notice that all the Cyan cells (30 to 39 meg in SALES) are sized to the whirligig of the spreadsheet and then alphabetized by AUTHOR inside the Cyan colored cells. The reside of the spreadsheet is grouped by AUTHOR merely with all the left over SALES totals (except 30 to 39 million).

03 cyan cells sorted to the top alphabetized by authors name — Blue-green cells sorted to the clear alphabetized by Generator's name

For more samples and detailed instruction manual regarding classification by colors, values, and icons, and using conditional formatting, check out these 2 past articles: How to use Microsoft Excel's provisory formatting, and How to tailor-make Surpass conditional formatting.