21  To identify items below the average value select  Below Average  instead of Above Average. 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 highlight cells that are above the average value of your data: Above Average  1. Highlight the data range. 2. Select  Conditional Formatting . 3. Hover over  Top/Bottom Rules . 4. Select  Above Average  to open the Above Average dialogue box: 