Formatting every 3rd line in 2007
 

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!

Formatting every 3rd line in 2007
 

How about Conditional Formatting
Formula such as =MOD(ROW(),3)=1 will pick out every third row
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Brenda from Michigan" wrote
in message ...
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!

Formatting every 3rd line in 2007
 

Hey, that's works great!!!! Thanks for the tip.

"Bernard Liengme" wrote:

How about Conditional Formatting
Formula such as =MOD(ROW(),3)=1 will pick out every third row
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Brenda from Michigan" wrote
in message ...
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!