View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default row placement & alternating highlighting

1) conditional formatting:
Formula Is
=MOD(ROW();2)=0
and select grey interior, then copy and paste special as formats
this will not color the whole rows, only specific cells

2) select a cell somwehere in 2nd row and go to Window-Freeze Panes