Thread: Change conditional formatting to coloured alternate rows dependent on a change in date?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Change conditional formatting to coloured alternate rows depen
And u can get difrent patterns modyfying the formula like:

=MOD(ROW();3)=0
=MOD(ROW();4)=0
=MOD(ROW();3)
=MOD(ROW();4)

and so on

Reply With QuoteReply With Quote