Colored cells in Microsoft Excel can help you organize data, track changes, and make it easier to read. For example, in a customer spreadsheet, you can use a green background to track which customers have made a sale. But how do you count these colored cells?

Excel has a Find & Select feature that lets you count cells with different colors. Here's how to use it:

The subtotal function allows you to count the number of formatted cells according to data filters. Here's how to use the filter function to count colored cells:

=SUBTOTAL(103, A2:A10)