Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal line or target line to Excell 2007 Chart | Charts and Charting in Excel | |||
Line graphs in Excel 2007 | Charts and Charting in Excel | |||
Line chart formatting | Charts and Charting in Excel | |||
Excel 2007 - Can I add to a Line of Best Fit | Charts and Charting in Excel | |||
Multi-line Formatting | Excel Discussion (Misc queries) |