How Do I Highlight Columns And Rows In Excel?

How Do I Highlight Columns And Rows In Excel?

How do I automatically highlight rows in Excel? In the format cells window, switch to the fill tab, and choose the color you want to use as the color to highlight the active row. Then click OK on the Format Cells window, and OK on the New Formatting Rule window. At this point, Row 1 should be highlighted with the color you selected.