Author: Oscar Cronquist Article last updated on October 19, 2018

The image above shows top 10 values using conditional formatting applied to cell range B2:G13.

How to format

  1. Select cell range.
  2. Go to tab "Home" on the ribbon if you are not already there.
  3. Click on "Conditional Formatting" button.
  4. Click on "Top/Bottom Rules".
  5. Click on "Top 10 Items..."
  6. A dialog box appears see image above, choose how many top items you want to highlight, the default value is 10. The drop-down list contains preconfigured formattings. "Custom Format.." opens another dialog box with more detailed settings.