Another great tool that Shawn can use to find information in a spreadsheet, is Conditional Formatting. You can find the conditional formatting button under the Home Tab in your ribbon, and you'll see a button called Conditional Formatting. Let's start with looking at the total column, highlight column W. Now click on Conditional Formatting. As a few options, we'll start with highlight cell rules. Click on greater than. Now Excel will default with a number there don't stress, you can of course edit it. Let's say I want to see all the cells that are greater than 100 I'll type 100 directly into that cell, as you can see there is live formatting here for you, Excel is now highlighting all of the values that are greater than 100. You can even change the highlight color as a drop down menu here, click on that, and you can change that to yellow, green, you can change it to light red, but with black text, have a play around, and see what you like. Let's stick with the default light red, with dark red text. Click on Okay. Whenever you want to get rid of your conditional formatting, click on Conditional Formatting, and click on clear rules. Then you can choose clear rules from selected cells or you can clear rules if you had several rules in your spreadsheet and then you click on clear rules from entire sheet. Let's click on Clear Rules from Selected Cells, and your conditional formatting has disappeared. Let's see what other options we have, back to conditional formatting click highlight cell rules, you can highlight cells that are less than a certain number in between a certain range equal to an exact number. This option texts that contains is only going to be useful for text data. You've got an option for highlighting cells based on dates as well. Let's try Text that Contains, which means I need to highlight a column that contains text. I'm going to highlight the account manager column, click on Conditional Formatting, click on Highlight Cell Rules, click on Text that Contains let's say, I want to see all the instances of Radhya, type that in, and you can see that every instance of Radhya Staples has been highlighted in your spreadsheet. Click on Okay. Remember if you want to undo the conditional formatting, click on Conditional Formatting, click on Clear Rules, clear rules from selected cells. Click on Conditional Formatting. You've got some top bottom rules. Top 10 items, top 10 percent. Bottom 10 items, bottom 10 percent above average, below average so the top bottom rules are not going to work on text data. I'll need to choose total sales of some numeric data, to apply these conditional formatting rules. There are some other very interesting tools in conditional formatting; Data Bus this is really cool. Click on Data Bus, and you'll see all these little bars different colors based on your preference. Let's click on the blue icon. What's happened is, Excel has put what it calls a data bar into each cell. Higher numbers have longer data bus, smaller numbers have very short data bus. It's essentially giving a visual representation of large numbers, versus small numbers. Back to conditional formatting, clear rules, clear rules from selected cells. Let's go back to conditional formatting to see what else we have. Color scales let's talk about that. As you can see that 28,000, it's quite a large number relative to everything else in total, it's a dark green, the 7,000 is kind of in the middle, the 2,000 is also kind of in the middle it's a lighter green, and all these numbers $14, $7, $24 even 865, is a white color. Back to conditional formatting, clear rules, clear rules from selected cells. Another great tool in conditional formatting is Icon sets, this is really cool. Let's use this one it looks a bit fun. As you can see some of the numbers have turned into hashes, so we'll need to fit the column width. Okay. What's happened here? Larger numbers you can see the bars full, medium numbers you can see three bars or two bars. The smallest numbers you can only see one bar. Again, it's a great visual representation of numerical data, rather than the numbers itself. If you want to get a quick overview of what you have. So, as you have seen, there are several different ways you can conditionally format your data, have a play around with data bars, color scales, and icon sets. In later courses we will talk about creating your own new rules. But for now, have a play around with what we've gone through.