Hi,

Use Conditional Formatting.

Select the first (topmost) row you want to highlight;

"Format" (in the Toolbar) -- "Conditional Formatting" -- select "Formula
Is" and in the formula bar enter
=MOD(ROW(),2)=0 (if that row is an even-numbered row), or
=MOD(ROW(),2)=1 (if that row is an odd-numbered row)
Click the "Format" button, and select "Patterns" and select the shading color,
Click "OK".
Now fill-in the formula in the rows below.

Regards,
B. R. Ramachandran




"Rachel" wrote:

I need to select every other row to highlight them. If there is a way to do it
more quickly than holding down the control key and selecting every other
line that would be very helpful