archive

Archive for August, 2011

Excel: Automatically alternate row colors (one shaded, one white)

Monday, August 29th, 2011

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.