Padding Numbers In the previous example you saw that we can format numbers and force then to display a fixed number of decimal places. The 0.00 part of the custom format makes this happen. For example ...

To create a heatmap chart in Excel, you need to use the Color Scales option. For that, select the list of numbers and choose the Color Scales option from the Conditional Formatting menu.