Press the Ctrl + F shortcuts to open the Find and Replace dialog box. Select the range that you want to select the cells by specific color.Ģ. And you can do it with following steps:ġ. You may want to select cells by cell color, the Find command can help you quickly select the same color of the cells. And then click OK button, all cells with the same color you specfied have been filtered at once, see screenshot:ĭownload and free trial Kutools for Excel Now ! Then click Ok button, and a promot box will pop out to remind you how many matched cells have been found, see screenshot:Ĥ.

In the Special Filter dialog box, select Format option, then choose Background Color from the drop down list, and then click button to select a color that you want to filter out, see screesnhot:ģ. Seelct the column that you want to filter by background color, and then click Kutools Plus > Special Filter > Special Filter, see screenshot:Ģ. Note: To apply this Special Filter, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.Īfter installing Kutools for Excel, please do as this:ġ. If you have Kutools for Excel, with its Special Filter feature, you can quickly filter all cells which filled with same background color. Then it shows the rows whose cells are filled by selected color, and hide other rows quickly. Click the button, and move mouse over the Filter by Color item, and select one color to filter.Ĥ. Then the filter arrow button will be appeared besides the title of selected column.ģ.

Select the column that you want to filter by cell color, and click Data > Filter, see screenshot:Ģ. You can filter rows by cell color with following steps:ġ. Select cells by cell color with Find command If you have a worksheet with using different colors to indicate different type of contents and you want to filter or select those cells by the cell color, you may get it done as follows:įilter rows by cell color with Filter commandįilter rows by cell color with Kutools for Excel Normally you can fill cells with different colors for any purposes in Excel. How to filter or select cells by cell color in Excel?

Apply color filter online