View Single Post
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default

Try conditional formatting. Select the entire range to be affected (all rows,
not just alternate rows), then Format/Conditional and select Formula Is in the
first box and type =MOD(ROW(),2)=0 and set the format for the shaded rows.
That will do even numbered rows. If you want odd numbered, change the final 0
to 1.

On Wed, 5 Oct 2005 13:54:06 -0700, 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