在Excel中创建彩色的Harvey球

It’s easy to add conditional formatting icons in Excel, by selecting one of the built in options. These were introduced in Excel 2007, and improved in Excel 2010. However, you still can’t get all the icons in any colour. For example, you can show Harvey Balls (the 5 Quarters icon set), but only in black and white. We'll see how to create colored Harvey Balls in Excel.

通过选择内置选项之一，可以轻松地在Excel中添加条件格式设置图标。 这些是在Excel 2007中引入的，并在Excel 2010中进行了改进。但是，您仍然无法获得所有颜色的图标。 例如，您可以显示Harvey Balls (5个季度的图标集)，但只能以黑白显示。 我们将看到如何在Excel中创建彩色的Harvey Balls。

创建自己的图标 (Create Your Own Icons)

One way to overcome this limitation is to create your own icon set. I showed one way to do this last year, and you can see the details here.

克服此限制的一种方法是创建自己的图标集。 去年，我展示了一种执行此操作的方法，您可以在此处查看详细信息 。

That technique used formulas to get a symbol from a lookup table, and the cells had to be formatted in Wingding font.

该技术使用公式从查找表中获取符号，并且单元格必须使用Wingding字体设置格式。

以数字格式显示符号 (Show Symbols With Number Format)

Last week, Jim McGarity sent me a sample file with his version of icon sets. Instead of using a formula to pull the icon into the cell, Jim created custom number formats.

上周，吉姆·麦加迪(J