Exam 77-427 Microsoft Excel 2013 EXPERT 2. Apply Custom Formats and Layouts 2.2 Apply Advanced Conditional Formatting and Filtering: Apply Rules (Top/Bottom) Choose the Formatting What Do You See? You will be prompted to select the colors when you select a Top/Bottom Rule.   In the example on this page, the suggested color is red, which isn't what people expect if the amount is ABOVE the Average.   Green means go: It is used to indicate financial success.   3. Try It: Format Cells  Select Green Fill with Dark Green Text, please. Click OK. The Amount in Column H will be formatted Green if it is Above Average.

Home-> Styles-> Conditional Formatting-> Top/Bottom Rules