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.

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.

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.

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.

To lock cells in Microsoft Excel, follow the methods below. A Format Cells dialog box is open. In the dialog box, click the Protection tab. On the Protection tab page, check if the lock checkbox ...

Safeguard your Excel worksheets from accidentally deleting formulas or data sets by locking important cells, while leaving the rest of the worksheet editable.

Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.

How to Format Fractions to Percentages in Excel. The cells in a Microsoft Excel spreadsheet can hold various types of numerical data, including fractions and percentages.

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