Article Edit Discuss

Filter Cells by Cell Color in Excel

Edited by Djinu, VisiHow, Eng, Visihow Admin

3 Parts:

Steps

Video: Filter Cells by Cell Color in Excel

Comments

You're watching VisiHow. In the last video, we showed how to highlight a cell if it matches information in another column. In this video, we're going to show how to filter only the highlighted cells.

Was this helpful? Yes | No| I need help

Filter only highlighted cells in Excel.mp4-canvas49 712995.jpg

Steps

1
To do this, click "Data"
.

Was this step helpful? Yes | No| I need help
2
Then click "Filter"
.

Was this step helpful? Yes | No| I need help
3
Click the arrow in row "1" and, for this tutorial, column "C"
.
Was this step helpful? Yes | No| I need help
4
Click "By color" under "Filter"
.

Was this step helpful? Yes | No| I need help
5
Move the cursor to "Cell Color"
.
Was this step helpful? Yes | No| I need help
6
Then, click the green color
.
Let's assume that it will indicate that the domain is available.

Was this step helpful? Yes | No| I need help
7
Now, close this menu
.
Excel will show only the items that are colored in green. It will hide all of the other text.
Was this step helpful? Yes | No| I need help

That's how you filter cells by color using Excel. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!