If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|