From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Conditional formatting and sorting icons

Conditional formatting and sorting icons - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Conditional formatting and sorting icons

- [Instructor] We've got this table of scores, and we would like to liven things up a little bit. We want the happy faces to blue, sad faces to be orange, and we want that to happen automatically with conditional formatting, and then the next thing we want to do is sort the table so that the yeses are up top, and then score one is sorted descending. You got that? Alright, so when you're ready, pause the video, bring up the exercise file, get it all worked out, come back, and I'll take you through a solution. Alright, you're back. Now something that we have to pay attention to. Look at this formula. The happy faces are Js, and the sad faces are Ls. That's what we have to work with. So let's do the conditional formatting. Highlight the entire column, conditional formatting, highlight cell rules, text that contains J. Now it's highlighted all of the happy faces. We do not want this red default. We've got to click this arrow, custom format. We're on the font tab. We want blue. Let's pick…

Contents