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

Open your spreadsheet in Microsoft Excel 2007. Drag your mouse across the data you want formatted. To select entire rows, drag across the left-hand row numbers.

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.

Excel will show you the results by highlighting the rows before the reference date. This is all about how you can highlight the rows with dates earlier than today’s date or a specific date in Excel.

How to highlight rows in Excel. ... which can be a cell reference, a value, or even an expression. Let’s try that now: Select the data range, B3:E16–you want to highlight the entire row.