If you're upgrading to Excel 2010, you've probably noticed that the Conditional Formatting feature has changed quite a bit.
如果要升级到Excel 2010,则可能已经注意到条件格式设置功能已经发生了很大变化。
Now you can apply more than 3 rules, and there are fancy features like data bars and icon sets.
现在,您可以应用3条以上的规则,并且有一些精美的功能,例如数据栏和图标集 。
条件格式简介 (Intro to Conditional Formatting)
I've updated my Intro to Conditional Formatting page, to show Excel 2010 instructions, and made a new video to show the steps.
我已经更新了“条件格式简介”页面,以显示Excel 2010指示,并制作了一个新视频来显示步骤。
If you're looking for Excel 2003 instructions, they've been moved to this page: Excel 2003 instructions.
如果您正在寻找Excel 2003指示,它们已移至此页面: Excel 2003指示 。
观看Excel 2010条件格式视频 (Watch the Excel 2010 Conditional Formatting Video)
To see the steps for creating two conditional formatting rules in Excel 2010, you can watch this short video.
若要查看在Excel 2010中创建两个条件格式设置规则的步骤,可以观看此简短视频。
下载样本文件 (Download the Sample File)
To see the sample used in this video, and other conditional formatting examples, you can visit the Conditional Formatting Introduction page.
要查看此视频中使用的示例以及其他条件格式示例,您可以访问“ 条件格式简介”页面。
翻译自: https://contexturesblog.com/archives/2012/10/02/conditional-formatting-in-excel-2010/