In Excel, you may typically fill cells with various colors for any purpose. This article might help you if you have a worksheet that uses various colors to denote different types of contents and you want to filter or select certain cells based on the color of the cells. In this article, we will demonstrate to you how you filter by cell color in Excel.
You may download the following Excel workbook for better understanding and practice it by yourself.
2 Handy Approaches to Filter by Cell Color in Excel
Here in the following methods, you will learn to filter by cell color in Excel by utilizing the Filter command and using the Find Command. In this article, we create a sample data set where we use different colors in cells to filter our desired cell color from the data set.
1. Utilizing Filter Command to Filter by Cell Color
In this first method, we use the Filter command from the Data tab to filter our desired data range with a specific cell color. Then, follow the below steps to filter by cell color in Excel.
Step 1:
- Here, we will select the column from which we want to filter by cell color.
- Firstly, go to the Data tab.
- Secondly, choose the Filter command from the Sort & Filter group.
Step 2:
- Then, click on the Arrow button here in the image below.
Step 3:
- Here in this section, choose the Filter by color option first.
- Then, choose the yellow cell color by clicking on the Filter by Cell Color option.
- Besides, click OK.
Step 4:
- Finally, you will see the following rows whose cells are selected by yellow cell color, and the other unselected rows are hidden.
Read More: How to Filter by Color in Excel (2 Examples)
2. Using Find Command to Filter by Cell Color
If you decide to choose cells based on their color, the Find command can help you do it fast. And the steps below will help you.
Step 1:
- Firstly select the data range that you would like to select the cells by a specific color.
- Then, click on the CTRL+F from the keyboard shortcut.
Step 2:
- Here, the Find and Replace dialog box will open to you.
- Then, select the Format option.
- After that, click on the Choose Format From Cell… from the Find and Replace dialog box.
Step 3:
- Here, in the Find and Replace dialog box, click the Find All option.
- Additionally, it will filter out any cells with the same color as the chosen cell.
- After that, to select all cells, press Ctrl + A from the keyboard shortcut.
Step 4:
- Here are our selected rows in yellow cell color.
Step 5:
- Once all the cells that satisfy the requirements are selected after you close the dialog box, you can copy and paste them into any blank range you like.
- As a result, you will see the results on the right side with yellow cell color filtering.
Read More: How to Filter by Color Using Conditional Formatting in Excel
Conclusion
In this article, we’ve covered 2 handy methods to filter by cell color in Excel. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.
Related Articles
- How to Filter by Multiple Colors in Excel (2 Easy Methods)
- Excel Filter by Color and Text (with Easy Steps)
- How to Filter Multiple Columns by Color in Excel (2 Methods)
- How to Remove Filter by Color in Excel (5 Methods)