Thread: Conditional Forting - Make different row color work with autofilte
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steen Steen is offline
external usenet poster
  
Posts: 104
Default Conditional Forting - Make different row color work with autofilte
Hi

I am using the Conditional format formulat: =MOD(ROW(),2)=0 to color each
2'nd row in a different background color. Is it possible to make this work
even with filtered data (still coloring each 2'nd row when filter is active)?

/Steen

Reply With QuoteReply With Quote