content_image/673922.jpg content_image/673923.jpg content_image/673924.jpg
<img src='content_image/673922.jpg'>

## Above Average 

To highlight cells that are above the average value of your data: 

1. Highlight the data range. 

2. Select Conditional Formatting . 

<img src='content_image/673923.jpg'>

3. Hover over Top/Bottom Rules . 

4. Select Above Average  to open the Above Average dialogue box: 

<img src='content_image/673924.jpg'>

Select the type of cell formatting you wish to use. Select Ok . The cells which are above the average value of your data will now appear with the cell formatting which you selected. 

To identify items below the average value select Below Average  instead of Above Average. 

