View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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