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.
- 7Excel will show only the items that are colored in green. It will hide all of the other text.Now, close this menu.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 Jun 26, 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 26 Jun 2017.
Chicago / Turabian VisiHow.com. "Filter Cells by Cell Color in Excel." Accessed Jun 26, 2017. http://visihow.com/Filter_Cells_by_Cell_Color_in_Excel.
Categories : Microsoft Suites
Recent edits by: VisiHow, Djinu