Filter Cells by Cell Color in Excel
Edited by Djinu, VisiHow, Eng
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.
- 7Now, close this menu.Excel will show only the items that are colored in green. It will hide all of the other text.Advertisement
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
Referencing this Article
If you need to reference this article in your work, you can copy-paste the following depending on your required format:
APA (American Psychological Association)
Filter Cells by Cell Color in Excel. (2016). In VisiHow. Retrieved Mar 23, 2017, from http://visihow.com/Filter_Cells_by_Cell_Color_in_Excel
MLA (Modern Language Association) "Filter Cells by Cell Color in Excel." VisiHow, visihow.com/Filter_Cells_by_Cell_Color_in_Excel Accessed 23 Mar 2017.
Chicago / Turabian VisiHow.com. "Filter Cells by Cell Color in Excel." Accessed Mar 23, 2017. http://visihow.com/Filter_Cells_by_Cell_Color_in_Excel.
Categories : Microsoft Suites
Recent edits by: VisiHow, Djinu