From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Use conditional formatting to identify top and bottom values

Use conditional formatting to identify top and bottom values - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Use conditional formatting to identify top and bottom values

“

- [Instructor] Somebody started doing this manually, but here is what we want. What we really need is use conditional formatting to identify the top five values in this matrix and the bottom five. Then, can you explain why there might be 10 cells colored once we're done? And then we want the column headers sorted alphabetically. You got that? Get a handle on it, come back, meet you here and you can watch me do it. All right, let's get rid of this junk. I'm going to highlight all of this. Go to Home and then No fill, great. While that is still highlighted, I'm going to Conditional Formatting, Top/Bottom Rules, Top 10 Items. I'm going to go down. I actually want top five and what do I want the format to be? Let's see, let's go to Custom Format. I'm going to go to Fill and let's make it a gold fill. OK, and OK. okay, why do we have seven cells highlighted when we asked for the top five? And that's because we have…

Contents