创建报表并添加条件格式。
使用条件格式可视化关键数据趋势。
这是条件格式和数据透视表的总结。
That's the summary for conditional formatting and PivotTables.
在“格式”菜单中，单击“条件格式”。
“条件格式”命令位于何处？
条件格式可以让您更容易分辨出正在查找的内容。
Conditional formatting can make it easier to see what you're looking for.
点击两次，条件格式就被应用到我所选单元格区域上了。
With two clicks, the conditional formatting is now applied to the cells I selected.
第一，当设置列表的条件格式时，将会出现“格式化整行”的选项。
First, we added a "format entire row" option that appears when defining a conditional format rule on a table.
对报表参数的内部支持允许基于静态值对结果集进行条件格式设置和筛选。
Built-in support for report parameters provides conditional formatting and filtering of the result set based on a static value.
让我们来看看更高级的条件格式界面以及它是如何满足那些用户的需求的。
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).
另外，也能识别单元格的条件格式，包括正常格式，斜体填充和条件格式图标设置。
In addition, it also recognizes conditional formats on cells including regular formatting, gradient fills, and conditional formatting icon sets (which I discussed in previous posts here and here).
在Excel 2007中，错误将导致一系列条件格式不适用所有细胞的范围内。
In Excel 2007, errors in the range would lead to conditional formatting not being applied to all the cells in the range.
在我们下次的Excel 2010年后，我们将看到一个新的对象模型功能的条件格式。
In our next Excel 2010 post, we'll look at a new object model feature for conditional formatting.
如果应用了某个列表样式后，你仍能自由地应用条件格式或直接进行格式化操作来格式列表。
If a table style is applied, you are still free to format your table using either conditional or direct formatting.
您是否曾经使用范围的条件格式(如图示套，颜色表和数据酒吧)才发现您的一个公式评价一个错误？
Have you ever used ranged based conditional formatting (such as icon sets, color scales and data bars) only to find that one of your formulas have evaluated to an error?
在Excel 2010年，条件格式悄悄地忽略了错误，并继续申请条件格式到其他细胞的范围内。
In Excel 2010, conditional formatting silently ignores the errors and continues applying conditional formatting to the rest of the cells in the range.
最后，正如我以前简要谈到过的，我们通过对条件格式的底层架构进行重大改进来满足最主要的用户需求。
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.
今天，我想在此系列里再增加一篇文章，那就是我们在Excel数据透视表里使用条件格式所作的努力。
Today I want to add one more article to the series, which is the work we have done to make conditional formatting work really well in Excel PivotTables.
同样，用户不必做任何事情，只是添加该字段到数据透视表，以获取服务器基于集中的业务规则定义的条件格式而已。
Again, the user didn't have to do anything but add the fields to the PivotTable to get server defined conditional formatting based on centralized business rules.
同样，值得注意的是这些选项同样会出现在条件格式创建和管理的用户界面上，因此你不必依赖于该对象上的用户界面。
It's also worth noting that these options are also exposed in the conditional formatting creation and management UI, so you don't have to rely on the on-object UI.
为了在数据透视表里面提供一个强大的条件格式体验，我们现在将条件格式的规则与数据透视表联系起来，而不是与单元格了。
To provide a great experience with conditional formatting inside PivotTables, we now associate the conditional formatting rules to the structure of the PivotTable instead of to the cells.
你也可以用Excel里的条件格式满足某些条件的行的文字变成红色，然后在滚动文本时，注意观察红色行闪烁于灰色行之间的情形。
You can also use conditional formatting in Excel to turn lines red if they meet certain criteria, then notice the pattern of red flecks in the gray lines of text, as you scroll.
你们中有记得我发表的关于图标集的条件格式文章，可能已经领会到我们也使用那种技术在Excel12里作为一部分KPI特点。
Those of you that remember the conditional formatting post I wrote on Icon Sets have probably already figured out we are using that capability in Excel 12 as part of this KPI feature.
这是条件格式和数据透视表的总结。有了这些改进，数据透视表可以作为一个强大的数据研究，突出趋势，发现突出者，等等的工具来使用了。
That's the summary for conditional formatting and PivotTables. With these improvements, PivotTables can now be used as a great tool for exploring data, highlighting trends, spotting outliers, etc.
如果提供商提供一份标准格式合同(通常的惯例是这样的)，那么你必须对所有的条款和条件都十分地清楚。
If the vendor provides a standard form of contract (which is a general practice), then you must be must be fully aware of all the terms and conditions.
例如，如果需要通过电子邮件将一个通知发送给每个符合条件的有记录的帐户，那么很容易在应用程序中对xml格式的客户电子邮件地址列表进行迭代。
For example, if you need to E-mail a notice to every qualifying account you have on record, then iterating through a list of customer E-mail addresses in XML format is easy to do in an application.
箭头上的文字表示继续转换所必须满足的条件，总是使用格式“[条件]”来描述。
The text on the arrows represent conditions that must be fulfilled to proceed along the transition and are always described using the format "[condition]".
约定的可读性目标包括使用断行、将空格当做制表符和空白对待，以及条件语句的格式。
Conventions aimed at readability includes such things as the use of line breaks, treatment of whitespace like tabs and Spaces, and the formatting of conditional statements.
至此，您已经看到了如何编写XQuery来检索XML文档片段，创建新格式的XML输出，以及根据查询中指定的条件返回不同的输出。
By now, you've seen how to write XQueries that retrieve XML document fragments, create new forms of XML output, and return different output based on conditions specified in queries themselves.
至此，您已经看到了如何编写XQuery来检索XML文档片段，创建新格式的XML输出，以及根据查询中指定的条件返回不同的输出。
By now, you've seen how to write XQueries that retrieve XML document fragments, create new forms of XML output, and return different output based on conditions specified in queries themselves.
应用推荐