Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number ...

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.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.

Learn how to demonstrate your marketing data using sexy combination charts in Excel, with tutorials for PC (2013 and Mac (2011).

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

However, it’s easy to grab your attention with a format that alerts you to the due date. In this article, we’ll use conditional formatting to highlight due dates.