An Excel Options dialog box will open. Click the Formulas tab on the left pane.

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.

TL;DR Key Takeaways : Excel does not have a built-in feature to sum or count cells by color, but this can be achieved using three methods: Filtering with Subtotal, Name Manager with Helper Columns ...

You can type codes in VBA Editor to change the cell colors in Excel. Learn how to change the cell background color with VBA Editor in Excel.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.