Conditional Formats

Microsoft Excel has a library of Conditional Formatting including Data Bars, Color Sets and Icons.

 

Each of these formats is based on Conditional Formulas, or Rules. Let's start with a simple Rule: show me any amount that is above the average.

 

2. Try It: Above or Below Average?

Select Column H

In the sample spreadsheet, this is the column with the Amount.

 

Go to Home ->Styles.

Go to Conditional Formatting.

Go to Top/Bottom Rules.

Select: Above Average.

 

Keep going, you will be prompted...