Amazing Ways To Format Cells in Excel 2007极佳的方法，格式细胞在Excel 2007
Posted on January 31, 2008 at 6:01 am发布于2008年1月31日在上午06时01分
If you are used to using older versions of Excel, the conditional formatting options in Excel 2007 will amaze you.如果你习惯使用旧版本的Excel时，在有条件的格式化选项，在Excel 2007中 ，将让你惊奇不已。 Now, you can use conditional formatting to format every cell in a range based on your own criteria (and there are a lot more formatting options to choose from).现在，你可以使用条件格式格式的每间囚室都在射程根据自己的标准（有大量更多格式化选项选择） 。 For example, if you have a profit sheet that you want to color code all profits greater than $200 as green and all profits less than $200 as yellow and all losses as red, then it could take a while to do manually – especially if you have thousands of entries.举例来说，如果你有利润，资产负债表说，你想要的颜色代码，所有的利润大于200元，作为绿化和所有利润少于200元为黄色和所有损失为红色，那么它可能需要一段时间做手工-特别是如果你有数以千计的参赛作品。 Instead, use conditional formatting to do the work for you.相反，使用条件格式为您代劳。
Conditional formatting enables you to format significant amounts of data quickly and easily – while still being able to distinguish different types of data.条件格式可以让您的格式大量的数据传输速度，并容易-而仍能够区分不同类型的数据。 You can create rules for the formatting options that will allow Microsoft Excel to auto-format for you.你可以创造规则，为格式化选项，将允许Microsoft Excel来自动格式给你。 Here are the three simple steps followed in this example.这里有三个简单的步骤，然后在这个例子中。
1. 1 。 Select the cells you want to format.选择细胞你想要的格式。
2. 2 。 Click the Conditional Formatting button under the Home menu, Styles section.点击有条件格式化按钮下，民政菜单，风格节。
3. 3 。 Select your rules.选择你的规则。 For this example, we imposed three rules.对于这个例子中，我们所施加的三个规则。 The first was that any value greater than $200 was green.第一项是，没有任何价值大于200元，是绿色的。
The same logic was applied to the second and third rules.同样的逻辑适用于第二和第三个规则。 The second rule was that anything between $0 and $200 was formatted yellow.第二条规则是什么关系0元和200元，被格式化的黄色。 The third rule was that anything less than $0 was formatted red.第三个规则是，任何少于$ 0被格式化红色。
Here is what a portion of the finished spreadsheet looks like.这里是一个部分成品，试算表的雏形。
If you do not like these formatting options, Microsoft Excel 2007 has many different new Conditional Formatting options that you can use.如果你不喜欢这些格式化选项，微软Excel 2007中有许多不同的新条件格式可以使用的选项。 For example, you can insert Icons like colored arrows, bar charts like in the second example, or even a range of automatically selected colors like in the last example.例如，你可以插入图标一样颜色箭头，酒吧图表一样，在第二个例子中，或什至射程可自动选定的颜色一样，在最后一个例子。
If you later decide that you don’t want your cells to be conditionally formatted, all you have to do is clear the formatting.若您以后，您不希望您的细胞被有条件地格式化，所有你必须做的是明确的格式化。 To do this, select the Conditional Formatting button and select Clear Rules.要做到这一点，选择有条件的格式化按钮，并选择有明确的规则。 Then, select whether you want to clear the rules from only the selected cells or from the entire worksheet.那么，选择是否要明确规定只能由选定的细胞或从整个工作表。
Top Five Reasons to Use Conditional Formatting in Excel 2007前五大理由，使用条件格式和Excel 2007
1. 1 。 To make your data more visually appealing.为了使你的数据更加视觉上的吸引力。
2. 2 。 To make your spreadsheets easier to understand at a glance.为了使您的表格比较容易理解，在一览无余。
3. 3 。 To identify certain types of numbers for help in problem solving.以确定某些类型的号码，帮助解决问题。
4. 4 。 To assist you in drawing conclusions from your data.为了帮助你得出结论，从您的数据。
5. 5 。 To visually display to the user what is “good” or “bad” by using green and red.以视觉展示给用户，什么是"好"或"坏"用绿色和红色。
Using conditional formatting can help improve your spreadsheets.利用条件格式可以帮助改善你的电子表格。 They will be more visually appealing and will enable the user to see what the values are at a glance.他们将被更多的视觉吸引力，将让使用者可看到什么，价值观正处在一个一览无余。
This is a guest post by Karen Worthy, a tech enthusiast. 这是一个客户后，由克伦值得，高科技发烧友。
Technorati Tags: Technorati标记： Microsoft微软 , ， Microsoft Excel 2007微软Excel 2007中 , ， Excel卓越 , ， formatting格式化 , ， conditional formatting有条件格式化 , ， workbook作业簿 , ， spreadsheet试算表 , ， cell细胞 , ， data analysis数据分析 , ， rules for conditional formatting规则条件格式
If you enjoyed this post, make sure you 如果你喜欢这个职位，请务必 subscribe to my RSS feed 订阅我的RSS馈送 ! ！
» Filed Under »提起下 MS Office Tips微软Office秘诀
Related Posts相关职位
- Microsoft Excel Basics Tutorial - Learning how to use Excel Microsoft Excel的基础教程-学习如何使用E xcel
- Excel Basics - How to use the Conditional Sum wizard Excel的基本问题-如何使用有条件森精灵
- How to use Data Validation in Microsoft Excel to create dropdown lists如何使用数据验证在Microsoft Excel来创建下拉列表
- Excel Tips & Tricks - How to unprotect only a portion of an Excel spreadsheet Excel的提示和技巧-如何解除只有部分的E xcel试算表
- Excel Tutorial - How to make a simple graph or chart in Excel Excel的教程-如何使一个简单的图形或图表在E xcel
Thanks for the info Karen !感谢你们的信息克伦！
A useful article.一个有用的文章。