Exam 77-427 Microsoft Excel 2013 EXPERT
2. Apply Custom Formats and Layouts
2.2 Apply Advanced Conditional Formatting and Filtering: Create Advanced Filters

pic1
no
 
graphic1

Filter -> Filter by Color

 

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.