Thread: Conditional Formatting Shading For Visible Rows Only
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
manda
 
Posts: n/a
Default Conditional Formatting Shading For Visible Rows Only
I am using conditional formatting formula =MOD(Row(),2)=0 to shade
alternate rows, but when I hide a row the shading format is not
consistent. Is there way to shade alternate 'Visible Only' rows without
creating a macro?

Reply With QuoteReply With Quote