excel 条件保护单元格_在Excel 2007中使用条件单元格格式

excel 条件保护单元格

If you are working on a spreadsheet and want to be able to quickly see differences in numbers at a glance, you should use the new Conditional Cell Formatting in Excel 2007. With this you can change the background of a cell based on the data in the cell, almost like an inline chart.

如果您正在处理电子表格，并且希望能够一目了然地快速看到数字上的差异，则应使用Excel 2007中新的条件单元格格式。使用此功能，您可以根据表格中的数据更改单元格的背景单元，几乎像一个内联图。

Using Conditional Formatting

使用条件格式

Once you select the cells that you want to format, you can find the Conditional Formatting drop-down on the ribbon, which gives you loads of pre-set rules to choose from, like color scales.

选择要格式化的单元格后，您可以在功能区上找到“条件格式”下拉菜单，该菜单为您提供了许多可供选择的预设规则，例如色标。

This will automatically color the items based on the range they are in…

这将根据项目所在的范围自动为其着色。

You can also choose to use icons instead:

您还可以选择使用图标代替：

Reminds me of that commercial… more bars in more places…

让我想起了那个商业广告……更多地方有更多酒吧……

You can also create your own rule to color only cells that fit within a certain range, or greater than a certain number.

您也可以创建自己的规则，以仅对适合某个范围或更大数量的单元格进行着色。

This rule will only color cells greater than a certain amount, with the color you specify.

此规则只会使用您指定的颜色为大于一定数量的单元格着色。

This can be very useful, and you should note that you can apply a second rule to the same range. For instance, I added a second rule that colored items larger than 2000 with green instead of red.

这可能非常有用，并且应注意，您可以将第二条规则应用于相同的范围。 例如，我添加了第二条规则，即对大于2000的项目使用绿色而不是红色上色。

You can even create a completely customized rule by choosing the New Formatting Rule option.

您甚至可以通过选择“新格式设置规则”选项来创建完全自定义的规则。

If you’ve applied too many rules and want to start over, just select the cells and use the Clear Rules option to remove all the formatting.

如果您应用了太多规则并希望重新开始，则只需选择单元格并使用“清除规则”选项即可删除所有格式。

This is one of those really useful features that make Office 2007 a lot better than the prior versions.

这是使Office 2007比以前的版本好很多的真正有用的功能之一。

翻译自: https://www.howtogeek.com/howto/microsoft-office/using-conditional-cell-formatting-in-excel-2007/

excel 条件保护单元格