When you’re working in Excel, every second you can shave off of what you’re doing is invaluable. So here’s something that’ll come in handy if you need to find the top 10 or top 10% of items in a list on aspreadsheet you’re working in.
This is something any Finance staffer can do by using Excel’s Conditional Formatting.
Here’s what to do:
- Select the range of cells in the column that you want to evaluate
- Go to the Home tab, select the Styles group and click Conditional Formatting
- Hover your cursor over Top/Bottom Rules and choose “Top 10 items” or “Top 10%“
- On the next dialog box that shows up, you can the “10” to whatever number you’d like pinpoint, and
- Change how you’d like the selected cells to appear, in the same box.
That’s all it takes.
All in one place
If you’ve added any new blood to your Finance department, be sure to direct them to some of the previous Excel tips we’ve posted on the sits, such as the updated 2013 Excel shortcuts, as well as one of Resourceful Finance Pro’ss most popular all-time posts: 21 best Excel shortcuts — all in one place.