IF you have a range of data and you want to highlight, say, the top 10 values by giving them a unique fill color or font color, then follow these steps:
- In the Home tab, Styles group click Conditional formatting.
- Point to Top/Bottom Rules and click Top 10 Items.
- The Top 10 Items window will open.
- Specify the number of items to format (left) and the formatting options from the drop-down list on the right. If you are not satisfied with what is on the list, you can click Custom Format at the bottom and then set up your own.
- Your data will look like this.

















