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.
To real power of using Conditional Formatting is when you start to combine different formatting options to really highlight information that's on your spreadsheet. In this case, I'm going to add another condition onto this particular section of cells. I'm going to do that by selecting the cells, going back to my Conditional Formatting area, and I'm going to pick highlight cells that are between a certain range. I want to identify anything that's within the $10,000 to $20,000 range, and I want to highlight that by this formatting option here.
So once I click OK, it identifies for me that I have one piece of information that meets that criteria. Notice that it's highlighted more in red then green because of the rules that I have in place. SO you can see that you have more than one formatting condition on a set of cells. How can you manage those conditions to make sure that you have the right ones being applied in the right order? By going to Conditional Formatting menu and going down to the Manager Rules command, it then presents you with the rules that you have in play in that particular table. You can define new rules here if you are so inclined, and like to work in the formatting options in Excel.
You can edit existing rules by selecting a rule and clicking this Edit button, or you can delete a rule entirely. The rules will be applied in the order that their shown, so right now I'm going to apply the rule to say that the cell value is between a certain range of numbers, and I want that one applied first. SO I want anything that's within that particular range to be identified and read. If I wanted to move the rules around and have the Data Bar rule applied first, I simply select the rule I want to move, and I re-order it in that option. If I want to move these back to my original state, I simply move up, and this will be the first set of rules that are included.
In this particular rule, because I'm looking at a value in between a certain range, I can stop assessing the rules if this one becomes true. Let's see how that is applied. If I click Apply, then you'll notice that in my table, there's no more green bar in this particular cell. All it's doing is it's found that this criteria works, and it stopped analyzing the rules from then on. Those are some different formatting options for you to work with in the Conditional Formatting area. Next we're going to take a look at using templates styles and auto formats in your Excel 2007 application.
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.