使用条件格式可视化关键数据趋势。
今天，我想在此系列里再增加一篇文章，那就是我们在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.
约定的可读性目标包括使用断行、将空格当做制表符和空白对待，以及条件语句的格式。
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.
箭头上的文字表示继续转换所必须满足的条件，总是使用格式“[条件]”来描述。
The text on the arrows represent conditions that must be fulfilled to proceed along the transition and are always described using the format "[condition]".
AddComment窗口(图2)支持默认条件下能够使用的拼写检查程序，以及多格式文本和链接创建。
The Add Comment window (Figure 2) supports a spelling checker that is enabled by default, as well as rich text formatting and link creation.
您是否曾经使用范围的条件格式(如图示套，颜色表和数据酒吧)才发现您的一个公式评价一个错误？
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?
这是条件格式和数据透视表的总结。有了这些改进，数据透视表可以作为一个强大的数据研究，突出趋势，发现突出者，等等的工具来使用了。
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.
在给出非线性有限差分格式的稳定性条件时，所使用方法非常简单和有效。
The approach used is extraordinary simpleness and availability in gaining the stability condition of the scheme.
你们中有记得我发表的关于图标集的条件格式文章，可能已经领会到我们也使用那种技术在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.
你们中有记得我发表的关于图标集的条件格式文章，可能已经领会到我们也使用那种技术在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.
应用推荐