From the course: Excel: Conditional Formatting for Beginners
Join today to access over 24,700 courses taught by industry experts.
Format based on Top/Bottom Rules options - Microsoft Excel Tutorial
From the course: Excel: Conditional Formatting for Beginners
Format based on Top/Bottom Rules options
- [Narrator] We're looking at the worksheet top bottom rules in our chapter one file. We have sales quotas in column D, actual sales in column E, and we'd like to highlight the higher entries for sales in column E. Now, we could be sorting the data, but let's say we want to maintain the order of this list as it is now based on the data over in column A. It's alphabetical. So selecting column E, let's go to conditional formatting. Now, we certainly could highlight cell rules greater than a certain amount, but for greater analytical capability, why not top bottom rules? And you'll notice we see top 10 items, farther down, bottom 10 items. We also have top 10%, bottom 10%. Now, this list has 150 rows or so. So the top 10% would mean we're about to highlight 15 of these. Top 10 means just 10. But in all cases here, these numbers can be altered easily. Let's choose top 10% first. And you see immediately, they're being highlighted, but I'm going to make them green instead. So scrolling up…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
