更多有關條件格式的內容……

更多有關條件格式的內容……

譯者：Kevin? 來源：http://blogs.msdn.com/excel 發表于：2006年7月7日

Another goal that we had for conditional formatting was to address top customer requests, like more than three conditions, the ability to reorder conditions, and the ability to have more than one condition resolve true. Let’s take a look at some of the more advanced conditional formatting UI and how it allows us to address those customer requests (again, UI is not final). First, let’s look at the “Conditional Formatting Rules Legend” dialog: 我們有關條件格式的另一個改進目標是滿足用戶的最主要的需求，比如多于三個條件、錄制條件的能力、多重條件判斷。讓我們來看看更高級的條件格式界面以及它是如何滿足那些用戶的需求的。首先，讓我們看看“條件格式規則圖例”對話框：（譯者注：在最新版本中，已經改為“管理規則”）

The Conditional Formatting Rules Legend dialog is the one-stop place to view and manage all the conditional formats in a workbook. Using this dialog, you can: ?View existing rules – you can view the rule condition, the range it is applied to, and the format set on the rule. The ‘Show Formatting Rules for’ dropdown at the top of the dialog allows you to change the scope of the rules you are looking at. You can view rules for the selected cells, the current worksheet, the current Table, other worksheets in the book, other Tables in the workbook, or the entire workbook. ?Add new rules via the New Rule button. More on this below. ?Change the order in which rules are evaluated. This is done using the up and down arrow buttons. ?Edit existing rules via the Edit Rule button. The Edit Rule UI is the same as the “New Rule” UI explained below. ?Delete rules via the Delete Rule button. ?Control whether more than one Rule can evaluate to true. More on this below. 這個對話框可以實現對工作簿中所有的條件格式進行一站式查看與管理，你可以： ?查看現有的規則——你可以查看規則包含的條件，應用的區域和目標格式。對話框上方的‘Show Formatting Rules for’(顯示規則范圍)?下拉列表允許你選擇查看不同范圍中的規則。你可以選擇查看應用于選定單元格的規則、當前工作表中的規則、當前列表中的規則、工作簿中其他工作表的規則、工作簿中其他列表的規則或者整人工作簿中的規則；? ?使用‘New Rule’（新建規則）按鈕來添加規則； ?利用向上或向下的箭頭按鈕改變規則的優先級；? ?使用‘Edit Rule’（編輯規則）按鈕來重新編輯現有的規則。新建規則和編輯規則的界面都將在下文中展示； ?使用‘Delete Rule’（刪除規則）按鈕來刪除規則； ?控制是否會有多個條件為真的規則。

When you press New Rule on the Conditional Formatting Rules Legend dialog, or when you select More Options … from the conditional formatting gallery fly-outs, you will see the “New Rule” dialog: 當你在上面這個對話框中選擇新建條件，或者在條件格式的圖形目錄中選擇“更多選項”時，你將看到“新建條件”對話框：

This dialog allows you to add new conditional formats to the selected range. Through this UI, you can add all the conditional formats that are available through the ribbon as well as a set of additional, slightly more sophisticated conditional formats. In addition, you can change the different settings and parameters on any conditional format. We have broken down our conditional formats into a few categories which are listed in the top of the New Rule dialog under “Select a Rule Type”. The bottom part of the dialog contains the Rule Description which changes based on the rule type selected above. Here is a summary of the categories: 這個對話框允許你向選定的區域新建條件格式。通過這個界面，你可以像使用Ribbon時那樣來創建所有可用的條件格式。事實上，你可以改變每種條件格式的設置與參數。我們已經把所有的條件格式分類并以列表方式顯示在“新建規則”對話框中“選擇條件類別”的下方，并且在對話框的下半部分根據選定的規則類別來顯示不同的細節設置。下面簡述這些規則分類：

?Format all cells based on their values – Use this to create a data bar, 2-color or 3-color color scale, or icon set rule. ?Format only cells that contain… – Use this to create the Excel 2003-style rules and more (format cells greater than, less than, greater than or equal to, less than or equal to, equal to, not equal to, between, not between). This is also the entry point to create rules of type: specific text, date occurring, blanks, non-blanks, errors, non-errors. ?Format only top or bottom ranked values – Use this to create top n, top n%, bottom n, bottom n% rule types. ?Format only values that are above or below average – Use this to create above average, below average, 1 or 2 or 3 standard deviation above, or 1 or 2 or 3 standard deviation below rule types. ?Format only unique or duplicate values – Use this to create rules that format unique or duplicate values. ?Use a formula to determine which cells to format – Use this to create Excel 2003-style rules where you can enter a formula to determine whether a format should be applied. ?Format all cells based on their values（根據單元格的值來格式化）– 創建data bar, 2色或3色的color scale，或者icon set ?Format only cells that contain…（單元格包含時格式化） – 創建 Excel 2003風格的規則或者更多(大于、小于、大于或等于、小于或等于、等于、不等于、界于…之間，不在…之間)。通過這里也可以創建這些類別的規則：指定的文本、日期，空白，非空白，包含錯誤，不包含錯誤。 ?Format only top or bottom ranked values（按最高或最低排名格式化） – 創建top n, top n%, bottom n, bottom n% 的規則。 ?Format only values that are above or below average （按高/低于平均值來格式化） –根據單元格在區域中高于平均值，低于平均值，大于等于平均值，小于等于平均值，高1、2、3個標準偏差，低1、2、3個標準偏差來創建規則。 ?Format only unique or duplicate values （根據唯一值或重復值來格式化）– 創建基于唯一值或重復值的規則。 ?Use a formula to determine which cells to format （使用公式判斷需要格式化的單元格）– 創建Excel 2003風格的，使用公式判斷哪些單元格需要格式化。

Finally, as I touched on briefly in one of my initial posts, we have also made some significant improvements in the infrastructure of conditional formatting based on top customer requests. We changed the following in Excel 12: 最后，正如我以前簡要談到過的，我們通過對條件格式的底層架構進行重大改進來滿足最主要的用戶需求。我們在Excel 12中做了以下改變：

?Number of conditions on a range is no longer limited by number. In Excel 2003, you could create conditional formatting rules with 3 conditions. Now, you are no longer limited by number; you are only limited by system memory. ?Multiple conditions evaluating to true. In Excel 2003, there could only be one conditional format applied to a given cell. If more than one conditional format evaluated to true, then only the format associated with the first conditional format was applied. We now allow you to have multiple conditional formats on a cell applied if more than one condition evaluates to true. For example, assume you have one conditional format that makes font style bold when true, and another that makes the cell background colour red when true. If both conditions are true, you will see both formats applied (bold text and red cell background color). When the formatting is conflicting (for example red font and green font), the first rule wins. This can be turned on or off for any rule using the checkboxes on the Conditional Formatting Rules Legend dialog. ?References to other worksheets. In Excel 2003, you could not reference ranges on other worksheets in a condition. Excel 12 allows cell references anywhere in the workbook. ?Support for Number formatting in conditional formatting. In Excel 12, the Number tab in the Format Cells dialog will be available in conditional formatting so you can set conditional formatting to be number formatting. ?同個區域的條件數量不再限制。在Excel 2003里面，你只能為條件格式的規則創建3個條件，現在你不再受此限制，你能創建的條件數量只受限的系統內存。 ?多個為真的條件。在Excel 2003里面，只能有一個被足條件的對應格式應用到單元格里面，如果多個條件為真，只有第一個對應的格式被應用。我們現在允許你有多個滿足條件的格式被應用。比如說，假設你有一個條件格式是當條件為真時設置字體加粗，而另一個條件為真是設置單元格的背景色為紅色。如果兩個條件同時為真，你可以看到兩個格式都被應用到單元上去了（加粗字體和紅色單元格背景）。當格式之間有沖突時（如紅字和綠字），第一個條件對應的格式有效。這一項功能可以利用“Conditional Formatting Rules Legend”對話框中用每條規則里的復選框來開啟和關閉。 ?引用其他工作表。在Excel 2003里面，你不能引用其他工作表的區域作為條件（譯者注：可以使用名稱來解決這個問題，但作者的本意是不能直接引用）。Excel 12允許引用工作簿中的任意一處。 ?在條件格式中支持數字格式。在Excel 12里面，設置條件格式時，單元格格式對話框中的“數字”標簽已經變為可用，所以你可以在條件格式中設置數字格式。

With that, we have largely summarized our investment in conditional formatting for Excel 12. Next time, I will briefly cover how this works in the object model, and then on to formulas and functions. 至此，我們已經大量討論了Excel 12中條件格式方面的改進。下一次，我會談談條件格式如何在對象模型中被操作以及公式與函數。

Published Thursday, October 13, 2005 12:04 AM by David Gainer

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。