To highlight a cell or row in Excel, we will be using Conditional Formatting. The Conditional Formatting feature easily spots, trends and patterns in your data using bars, colors, and Icons to ...

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 you want to highlight a single cell in the subtotaling rows, select only the single column before applying the conditional format. You could even add a second conditional formatting rule.