background-color every second row

[ndog37]

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

 

[Guest]

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

 

[Bob Phillips]

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)