Thread: Conditional formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
  
Posts: 461
Default Conditional formatting
Highlight all the cells, go to conditional formatting and put in the formula

=MOD(ROW($A1),5)=0

"WallyZ" wrote:

How do I underline every fifth row in an Excel 2007 worksheet?
Reply With QuoteReply With Quote