Line 163 Excel Address Template
Try this
Select last two rows with the highlight you want. Click on the PAINT BRUSH icon Select the rows you want to highlight or Copy last two rows Select the rows you want to highlight Right-click, choose Paste Special and then click on FORMATS and OK "mtnrider" wrote: I am in the process of creating an Address list to be used for a mail merge in the future. The template begins as I expect, with odd numbered rows being shaded blue and even numbered rows with no color. At line 163, the alternating row color stops. All rows are white (no fill). I've tried a number of formatting fixes, but nothing works. I even tried to start the sheet over. Again, alternating color stops at Line 163. How do I continue the alternating color of rows for the rest of my sheet? My thanks. P. S. Hope I've explained this properly. -- mtnrider |
Line 163 Excel Address Template
Select all the rows you want banded.
FormatConditional FormattingFormula is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Format to blue and OK Gord Dibben MS Excel MVP On Thu, 26 Feb 2009 14:24:01 -0800, Sheeloo <Click on my name above to get instructions for getting my email id wrote: Try this Select last two rows with the highlight you want. Click on the PAINT BRUSH icon Select the rows you want to highlight or Copy last two rows Select the rows you want to highlight Right-click, choose Paste Special and then click on FORMATS and OK "mtnrider" wrote: I am in the process of creating an Address list to be used for a mail merge in the future. The template begins as I expect, with odd numbered rows being shaded blue and even numbered rows with no color. At line 163, the alternating row color stops. All rows are white (no fill). I've tried a number of formatting fixes, but nothing works. I even tried to start the sheet over. Again, alternating color stops at Line 163. How do I continue the alternating color of rows for the rest of my sheet? My thanks. P. S. Hope I've explained this properly. -- mtnrider |
All times are GMT +1. The time now is 09:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com