Thread: Change colour of rows in a worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
  
Posts: 553
Default Change colour of rows in a worksheet
Use Conditional Formatting.

Following formula would set your desired color to the every 7th row .

=mod(row(),7)=0

"VJ Sharma" wrote:

How can I change each nth row's colour in a worksheet?
Reply With QuoteReply With Quote