Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
We're now going to take a look at something that's very powerful in Excel 2007, and that's Conditional Formatting. For those of you that would like to follow along, please open EatCake Sales Forecast5, found in your Exercise Files. What does Conditional Formatting do? Let's take a look at the description that we find on the ribbon. As we mouse over the Conditional Formatting option, on the Home tab of the ribbon, it explains to us that conditional formatting will highlight interesting cells, emphasize unusual values, and using visual data such as data bars, color scales and icon sets, identify specific areas that you'd like to highlight in your table.
Let's see how this works in practice. First of all, select an area of the table that you would like to highlight. So by clicking on cell E4, and dragging until I reach cell E10, I've identified that that's the particular of the table that I want to work with. I go up to the Conditional Formatting section and click on the drop-down list. When I click on the Conditional Formatting option, I see a different set of commands available to me. And the one that we're going to take a look at is the highlighting cells rules. I want to identify areas in that particular section of the table that are greater then $500,000. So I select the Greater Than rule, click on it once, and put in the value that I'm looking to track. As I do that, you'll notice in the area that I've highlighted in the table, that it already identifies those values that are over $500,000. And it does so by filling them in with the formatting that you see in this drop-down list. If I'm happy with that, I can just click OK, and my Conditional Formatting is applied.
If I'd like to change up the formatting at any space in time, I simply go back to the command, I can either change the value that I am looking for, or the way that the information is displayed with a different formatting options. On my green background, I have to say that I like yellow a lot better, let's leave it at that. That's how easy it is to use the Conditional Formatting command in the new Home tab. Now let's take a look at how we can change, clear and adjust those conditional formats in our next movie.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 87287 Viewers
80 Video lessons · 136341 Viewers
59 Video lessons · 54998 Viewers
52 Video lessons · 68861 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.