Top/bottom Rules

We use this function to know which are the highter or lower values in a selected range. You can also use it to know which values are above or below average. And as in any of the options of Conditional Formatting, you can always change the criteria by clicking on More Rules. 

Example: 

Tutorial :

http://www.youtube.com/watch?v=gEbsijcdvks