Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,646
Default Line 163 Excel Address Template

Maybe there is conditional formatting with a formula like this
=MOD(ROW(),2)0
and it stops at row 163. If so, expand it!

Regards,
Stefi

€žmtnrider€ť ezt Ă*rta:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line 163 Excel Address Template Sheeloo[_3_] New Users to Excel 1 February 28th 09 05:13 PM
Does anyone have a template for printing L7160 address labels? Mackydees Excel Discussion (Misc queries) 3 July 7th 08 05:39 AM
Where is excel address book template? wfm100 Excel Discussion (Misc queries) 1 October 7th 06 04:21 AM
Is there a template for setting up a address book? Jace Excel Discussion (Misc queries) 1 August 22nd 05 03:42 AM
I need a Palm PDA address template to convert Excel spreadsheets CampDave Excel Worksheet Functions 1 May 16th 05 07:15 PM


All times are GMT +1. The time now is 11:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"