Filter Cells by Cell Color in Excel

Edited by Djinu, VisiHow, Eng, Visihow Admin

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.

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

Steps

  1. 1
    To do this, click "Data"
    .
    Filter only highlighted cells in Excel.mp4-canvas16 219997.jpg
    Was this step helpful? Yes | No| I need help
  2. 2
    Then click "Filter"
    .
    Filter only highlighted cells in Excel.mp4-canvas18 040997.jpg
    Was this step helpful? Yes | No| I need help
  3. 3
    Click the arrow in row "1" and, for this tutorial, column "C"
    .
    Filter only highlighted cells in Excel.mp4-canvas25 466268.jpg
    Was this step helpful? Yes | No| I need help
  4. 4
    Click "By color" under "Filter"
    .
    Filter only highlighted cells in Excel.mp4-canvas30 084289.jpg
    Was this step helpful? Yes | No| I need help
  5. 5
    Move the cursor to "Cell Color"
    .
    Filter only highlighted cells in Excel.mp4-canvas31 188995.jpg
    Was this step helpful? Yes | No| I need help
  6. 6
    Then, click the green color
    .
    Let's assume that it will indicate that the domain is available.
    Filter only highlighted cells in Excel.mp4-canvas36 72219.jpg
    Was this step helpful? Yes | No| I need help
  7. 7
    Now, close this menu
    .
    Excel will show only the items that are colored in green. It will hide all of the other text.
    Filter only highlighted cells in Excel.mp4-canvas39 990995.jpg
    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!

Video: Filter Cells by Cell Color in Excel

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

Article Info

Categories : Microsoft Suites

Recent edits by: Eng, VisiHow, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 204 times.

x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No