Shade alternate lines

W

wyattf

How can you shade alternate lines on a worksheet in order to make the result
more readable?
 
M

Martin P

Conditionally format cell A1 with Formula is =INT(ROW(A1)/2)<>ROW(A1)/2,
choose a pattern and copy the format to the entire worksheet.
 
Top