How to Format a Row Based on the Value of a Cell in Excel 2007. Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might ...

Merging Cells Picture this: you have a row in Excel where the same data applies to each cell. Rather than repeating the same value multiple times, you decide to click "Merge And Center" in the ...

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

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

The cell contents are still 20.5 so that value will be used in calculations, but the cell will show as 21 lbs. When you are creating a custom format you need to decide how you want your numbers to ...

How to Format Debits and Credits in Excel. When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance. Before you dive into an in ...

Pro Tip: To open formatting options, just select the cell (s) you want to format and press Ctrl-1 (Mac: Command-1). This actually works for anything in Excel: charts elements, images, etc.

If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue.

On the other hand, when someone pastes a date value, Excel ignores the destination cell’s format, retaining the formatting from the original source–not what users expect.