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 Dark Green if it is Above
Average.
Home-> Styles-> Conditional Formatting->
Top/Bottom Rules
Exam 77-882: Microsoft Excel 2010
Core
8. Analyzing and Organizing Data
8.3. Apply conditional formatting:
Top/Bottom Rules
|
|
| |
