See how to highlight just those cells that are in the top or bottom 10% or the top/bottom 10 items. Also, learn how to change the percent or number to any value you wish.
- [Instructor] If you're familiar with Excel's…filtering capability, you might have encountered…the terms Top 10 or even Bottom 10.…That same capability is available by way…of conditional formatting.…We might want to make the sales stand out,…the ones that are the top performers out of this list.…I'm going to select column E, Conditional Formatting,…and although Highlight Cell Rules has tons of choices,…we find this under that heading, Top/Bottom Rules.…And as soon as we choose one of these, for example,…Top 10 Items, you'll notice that instead of 10,…it could be any number we want.…
So depending upon the size of the list or how many we want…to have highlighted, we'll choose our own.…Certainly 10 is appropriate in some cases.…Once again, as with the prior examples,…formatting feature has already been applied here.…You like it or you don't.…If not, perhaps choose some of the others…or go into Custom Format.…Let's say this one works just fine, click OK.…So scrolling up and down this list of about 100 entries,…we've got 10 of them highlighted.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Conditional formatting based on content
- Formatting based on formulas
- Using data bars to display length or volume
- Using color scales to display relative differences
- Highlighting PivotTable results
- Applying banded rows