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.

We’ll tackle that next. How to count the color codes As is, the matrix returns the fill color codes for each cell in the data set. Using COUNTIF (), we can easily count the blue cells in each row.