Need to find the top 10 or top 10% (or 3% or 15%) of items in your list? Try Conditional Formatting using Top & Bottom Rules in Excel.
Select the range of cells in the column you wish to evaluate. On the Home tab, Styles group, click Conditional Formatting. Hover over Top/Bottom Rules and choose Top 10 Items or Top 10%. You can change the 10 on the next dialog box. On that same dialog box, you can also change how you wish the selected cells to appear. If you don’t like the presets, choose Custom Format.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/35459/need-to-find-the-top-10-or-top-10-of-items-in-your-list "