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

Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

Every Excel spreadsheet has summary rows, final outputs, or key performance indicators that need to stand out, and cell shading is an effective way to achieve this.

Want to highlight Cell or Row if a checkbox is selected? We show you hHow to highlight a Cell or Row with a Checkbox in Excel.

To lock your cells in Microsoft Excel, you just need to head into the program's "Protection" tab. Locking a cell in Excel will make it so viewers can't change the data inside of that cell, which ...