Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
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.
Find answers to the most frequently asked questions about Excel 2007 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.