Thread: freeze borders and shading
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
willem willem is offline
external usenet poster
  
Posts: 14
Default freeze borders and shading
Found Solution with conditional formatting for either rows or columns
=MOD(ROW()2)

automatically updates format either when inserting or deleting rows columns
etc

W
Reply With QuoteReply With Quote