Conditional Formats

Conditional Formatting emphasizes data that meets certain criteria. It is a quick, efficient method for focusing attention.

 

The following illustrations use the sales spreadsheet. You can use the sample spreadsheet  or enter your own data if you wish.

 

Try It: Above or Below Average?

Select Column H (In the sample spreadsheet, this is the column with the Amount).

 

Go to Home ->Conditional Formatting.

Go to Top/Bottom Rules.

Select: Above Average.

 

Format Cells: You will be prompted to select a formatting option. Select Green Fill with Dark Green Text, please.