There's a fine line between a well-formatted Microsoft Excel worksheet and one that's full of issues that take time to fix.

There are several ways to make data stand out visually in an Excel spreadsheet, but one of the simplest and most effective is to apply conditional formatting. Conditional formatting is a feature ...

One of Excel's most underrated features for project management is conditional formatting. This simple tool allows you to visually represent project data, keep tasks on track, and see which ones ...

When the Format Cells dialog box opens, it's automatically set to display Excel's numeric-data format options. Select a format category that matches your data type. For monetary values ...

they transform into the ugly duckling of data, and nothing stands out. But Excel gives you the option to dictate formatting for positive, negative numbers, and even 0. To format these numbers ...

Excel for the web supports rules in the conditional format feature, but you are limited to the formats you can choose. Because we’re formatting groups, the data must be grouped before you begin.

Yet, one of the biggest mistakes marketers make is trying to wrangle static data instead of taking advantage of Excel’s table formatting, which basically turns your data range into an ...

With Excel 2007's conditional formatting, you can add all sorts of eye-catching visuals to your data. Conditional formatting makes your spreadsheets more meaningful and easier to interpret ...

However, changing some file properties and formatting options may occasionally cause data to disappear. Excel offers different spreadsheet, basic text and Web page file formats to save your work.

Looking to track positive or negative changes in your Excel data? Mary Ann Richardson explains how you can use conditional formatting to find out this information automatically. Excel’s ...