Automatically alternate fill colors in worksheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to automatically format worksheets so that every other line is shaded; like in a checkbook register?
 
Yes, with conditional formatting.

Select the entire rows in your used range (I wouldn't select the entire worksheet). Then go to
Format/Conditional. Assuming A1 is the active cell, select Formula Is in the first box, and type
=MOD(ROW(A1),2)=0 and apply the shaded format you want. That will shade even rows. If you want
to shade odd rows, change =0 to =1.



Is there a way to automatically format worksheets so that every other line is shaded; like in a
Click to expand...
checkbook register?
 
Back
Top