Use conditional formatting to highlight important messages

- [Instructor] In older versions of Excel, … you had the choice to organize by color. … If you wonder where that feature has gone, … it's now called Conditional Formatting … and it's one of the advanced view settings. … I'm going to go to View first … and make sure I'm in the view … where I want to create conditional formatting … because it's view specific. … If you want it in every view, … you need to create it in every view. … I'm in the Compact View that I use all the time. … That's great, I'm going to choose View Settings … and click Conditional Formatting … and what we're basically going to be doing … is creating a rule. … A rule is a lot like creating a filter … or creating an advanced search. … We already have conditional formatting rules … being used in this view … and one that's created and is not in use right now … that's called Finance Email. … Okay and that would turn items green. … All right, that's okay. … But we're not going to use that, … we're going to add a new rule. …