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 ...

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.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.

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 ...

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.

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 ...

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.

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 ...

The formatting combination includes all the formatting options available in Excel, such as font size and style, adding borders and colors to cells or text, etc.