Thread: How do I set up alternate row shading with Excel 2003?
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 How do I set up alternate row shading with Excel 2003?
=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

This one will retain the banding when you filter the data.

=MOD(ROW(),2)=0 will not retain the banding through filtering.


Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 15:36:02 -0700, msk1944
wrote:


Reply With QuoteReply With Quote