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

 

 
graphic1

Home -> Conditional Formatting  -> Manage Rules

 

Bend the Rules

3. What Do You See? The Rule Type is a list of options. You can use a Rule to identify a cell by the values. The values can be based on the average or the rank. You can also use a formula in a rule.

 

The Rule Description is a tool for defining the values. You can select the formatting Style and type in your own Value if you wish.

 

You can edit each part of the Rule Description including the Icons, the values and the colors.

 

It's kind of fun. Click OK to return to the Rules Manager, and OK, again, to close the Rules Manager.

 

Very Good!

Keep going...