Conditional formatting lets you format cells in an Excel spreadsheet based on the cells’ content. For example, you could have a cell turn red when it contains a number lower than 100. You can also use conditional formatting to highlight an entire row?
通过条件格式设置,您可以基于单元格的内容来格式化Excel电子表格中的单元格。 例如,当单元格包含的数字小于100时,它可能会变成红色。您还可以使用条件格式突出显示整个行吗?
If you’ve never used Conditional Formatting before, you might want to look at Using Conditional Cell Formatting in Excel 2007. It’s for an earlier version of Excel, but the interface really hasn’t changed much. That guide talks about formatting specific cells based on their content. For example, say you use a spreadsheet to track hours that employees have worked. You could use conditional formatting to color cells red where an employee has worked more than eight hours in a particular day.
如果您以前从未使用过条件格式设置,则可能需要查看在Excel 2007中使用条件单元格格式设置。 它用于早期版本的Excel,但界面的确没有太大变化。 该指南讨论了根据特定单元格的内容设置格式。 例如,假设您使用电子表格来跟踪员工的工作时间。 您可以使用条件格式将员工在特定一天工作超过8个小时的单元格涂成红色。
But what if you wanted to use a cell’s value to highlight other cells? In the example we’re using for this article, we’ve got a small spreadsheet with movies and just a couple of details about those movies (to keep thinks simple). We’re going to use conditional formatting to highlight all the rows with movies made before 1980.
但是,如果您想使用一个单元格的值突出显示其他单元格该怎么办? 在本文所使用的示例中,我们有一个包含电影的小型电子表格,并且仅包含有关这些电影的一些详细信息(以保持简单性)。 我们将使用条件格式来突出显示1980年前制作的电影的所有行。
第一步:创建表格 (Step One: Create Your Table)
Obviously, the first thing you need is a simple table containing your data. The data doesn’t have to be text-only; you can use formulas freely. At this point, your table has no formatting at all:
显然,您需要的第一件事是一个包含数据的简单表。 数据不必是纯文本的。 您可以自由使用公式。 此时,您的表完全没有格式: