Highlight Entire Rows Based on a Cell Value Highlighting a row in an Excel sheet is a great way to indicate what you want someone to immediately focus their attention on.

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

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules.

In Microsoft Excel, you can achieve this effect using conditional formatting to change row or column colors based on their numbers.

Q. I know I can use conditional formatting to shade every other row (or every nth row) of an Excel data table. But how do you do that in a Word table? A.