Formatting every 3rd line in 2007

  • Thread starter Thread starter Brenda from Michigan
  • Start date Start date
B

Brenda from Michigan

User has Excel 2007. I have 2002 but I can remote in to the user's PC.

User wants a way to highlight or preferably underline every 3rd line in his
table and have the formatting stick when records are inserted or deleted in
the table. He does not like the formatting in the Table Styles. I was able
to create a new style to underline every line using borders within a Style,
but then we can't get just the 3rd line. Is there a way to do this in 2007
that does not require a programmer. Thanks!
 
How about Conditional Formatting
Formula such as =MOD(ROW(),3)=1 will pick out every third row
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top