Excel Color Font For Percentages Mac Users Should

For example, you can show Harvey Balls (the 5 Quarters icon set), but only in black and white.

I showed one way to do this last year, and you can see the details here.

Instead of using a formula to pull the icon into the cell, Jim created custom number formats.

So, well build a table that shows where each level starts, and the symbol for each level.

Visit the Microsoft website for more information on custom number formatting.

Because we used the question mark characters, the digits line up correctly.

The 9, in cell B3, is at the far right of the cell, and lines up with the final digit in the 100, in cell B6.

When you create the custom number formats, paste in the symbols, and dont enter the other characters.

Excel Color Font For Percentages Mac Users Should

Mac users should also note that while the choices in Excel 2011s Insert.Symbol dialog pale in comparison with those in Excel 2010 for Windows, they can also copypaste symbols from the Macs native Character Viewer into Excel for use with this technique.

How do you increase the size of the ball without going over a font size of 12.

Mac Excel Color Font For Percentages