Highlight top 10 % values
The image above shows top 10% values using conditional formatting applied to cell range B2:G13. Cell range B2:G13 contains 72 numbers, 10% of 72 is roughly 7. These seven values are then highlighted.
How to format
- Select cell range.
- Go to tab "Home" on the ribbon if you are not already there.
- Press with mouse on "Conditional Formatting" button.
- Press with mouse on "Top/Bottom Rules".
- Press with mouse on "Top 10 %..."
- 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, see image below.
Top bottom rules category
The image above shows top 10 values using conditional formatting applied to cell range B2:G13. How to format Select cell […]
The image above shows values above average using conditional formatting applied to cell range B2:G13. Cell range B2:G13 contains 72 […]
Conditional Formatting categories
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.