Thread: Conditional formatting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Conditional formatting
CF/ Formula Is/ =MOD(ROW(),5)=0/ Format with lower border.
--
David Biddulph

"WallyZ" wrote in message
...
How do I underline every fifth row in an Excel 2007 worksheet?


Reply With QuoteReply With Quote