All the cells of negative numbers will become red, while the positive numbers will remain the same. Click Conditional Formatting button in the Styles group. Click New Rule in the menu. Select a style, ...

One custom format field can scale numbers, add icons, apply color rules, and clean up visual clutter instantly.

Microsoft Excel gives you a boatload of options for changing the format of color charts. You can change the layout of a chart, then customize that layout to the format you prefer. For example, you can ...