Excel: Automatically alternate row colors (one shaded, one white)
Good tip here!
Most importantly:
When the Conditional Formatting window appears, select “Formula Is” in the drop down. Then enter the following formula:
=mod(row(),2)=1
Next, we need to select the color we want to see in the alternating rows. To do this, click on the Format button.