All the cells of negative numbers will become red, while the positive numbers will remain the same. You can create your own custom format in Excel to highlight negative numbers. Select the range of ...

Microsoft Office Excel can be configured to display a number with the default currency symbol. In addition to the options for currency symbols, the format has options for the number of decimal places ...

Excel is well known for making personal and business accounting easier. Two tools that allow for this capability are the program's Currency and Accounting number formats, which—alongside many other ...

Microsoft Excel has the ability to automatically recognize a positive or negative number that you enter in a cell. However, if an incorrect format is selected for the spreadsheet or certain cells ...

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

Please note: This item is from our archives and was published in 2009. It is provided for historical reference. The content may be out of date and links may no longer function.

There's a fine line between a well-formatted Microsoft Excel worksheet and one that's full of issues that take time to fix. Whether you're an Excel newbie or a seasoned pro, avoiding these formatting ...

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting. Data bars are a kind of conditional formatting, with the bar length based on the value of the ...