Thread: shading rows in excel
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default shading rows in excel
If you won't be filtering the data use the other suggestions.

If you will be filtering use this formula in CFFormula

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0


Gord Dibben MS Excel MVP

On Fri, 7 Aug 2009 11:47:01 -0700, juji
wrote:

How do I shade alternate rows in excel 2000

Reply With QuoteReply With Quote