background-color every second row
 

am looking for a quick way to background-color every second row
grey.

So for if example I have used rows 3-76, I want to background colour
every 2nd rows 4,6,8,10,12,14,16,18,20,22,24,26,28,30...76

Right now I need to left click and hold ctl button to manually
highlight them all, then click on the grey background color fill
tool.
But maybe there is an easier method!

Thanks

background-color every second row
 

Select the range you want to colour and then:

Format|conditional format|formula is| =MOD(ROW(),2)=0

and then select your colour and click OK.

Mike

" wrote:

am looking for a quick way to background-color every second row
grey.

So for if example I have used rows 3-76, I want to background colour
every 2nd rows 4,6,8,10,12,14,16,18,20,22,24,26,28,30...76

Right now I need to left click and hold ctl button to manually
highlight them all, then click on the grey background color fill
tool.
But maybe there is an easier method!

Thanks

background-color every second row
 

See http://www.xldynamic.com/source/xld.CF.html#rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
ups.com...
am looking for a quick way to background-color every second row
grey.

So for if example I have used rows 3-76, I want to background colour
every 2nd rows 4,6,8,10,12,14,16,18,20,22,24,26,28,30...76

Right now I need to left click and hold ctl button to manually
highlight them all, then click on the grey background color fill
tool.
But maybe there is an easier method!

Thanks