Use Rules to Filter the Data
You can use the Conditional Formatting to Filter the data by Color, Number or criteria.
4. Try This: Use Advanced Filters
Column H was formatted with an Icon Set that has four (4) arrows.
Select Cell H1. The Filter should be available.
Go
to Filter->Filter by Color.
Click on Filter by Cell Icon: Green.
The green arrow is when the value is greater than or equal to 75%. Microsoft Excel will display the Cells with Conditional
Formatting in Column H that meet the criteria.