In this lesson you will learn how to highlight every second row. Excel will highlight cells automatically instead doing it manually. Setting conditional formatting rules Select the range of cells that you want to apply the formatting to. To apply the alternating row highlighting, navigate to the Home tab