Can Excel Sort by Color? How to Fill Color and use Sort & Filter's Custom Sort

Can Excel sort by color? Absolutely. In addition to sorting by values, Excel can sort by cell color, font color, and cell icon.First, you must you must define the colors for your sort columns/fields. For this example, we’ll select colors based on the SALES column.1. Highlight all the rows with sales from 100 to 500 million. To choose a background color, click Home on the main menu row and go to the Font group. Find the paint-bucket icon that stands for Fill Color, and click the down arrow next to it. 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.To read this article in full, please click here