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.一個有用的文章。