See first: How to filter in Excel?
To filter by color, execute the following steps:
1- Select the data and press Alt + A + T.
Arrows will appear in columns’ header.
2- After clicking on an arrow, filter menu will open.
3- On the filter menu, press I or go to the Filter by Color option and select your required color. Click OK or Press Enter.
4- Result. Excel will show selected colored data only.
How to remove the color filter?
To remove the color filter:
1- Click on the arrow showing filter sign.
2- Click on the tick mark in the selected color area.
For more detail, visit Microsoft Office website.
Next Lesson: Number and Text Filter