Microsoft Office Tutorials and References
In Depth Information
Enhancing Reporting with Custom Number Formatting
So how do you know which color code to use? Well, in the Chapter 2 sample file, you will find a tab
called Get Color Codes (see Figure 2-15). The button found on that tab runs a small bit of VBA that
extracts the color and color code for you. Simply find the color you deem most appropriate and use
the associated code.
Figure 2-15: Use the Get Color Codes tab in the Chapter 2 Sample file to extract the Excel palette colors and
their associated codes.
You may be wondering how using custom number coloring is different from Excel’s built-in
conditionalformatting feature. In many ways, they’re the same. However, you do get a couple of benefits from
using custom number coloring rather than conditional formatting.
➤ You don’t have to manage separate conditional formatting rules. All the formatting needed
is built into the cell.
➤ Every object that uses your custom formatted cell adopts the format automatically. This
means your custom formatting can be applied where conditional formatting can’t. For
example, the chart in Figure 2-16 plots cells that have custom number formatting. Notice how the
y axis of the chart faithfully displays the custom number formatting. You couldn’t do this
with conditional formatting.
Figure 2-16: Custom number formatting is automatically adopted in charts.