 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2005Shading rows
Is it possible to shade every other row on an existing spreadsheet without manually shading? This would make it easier to read a list across the row. Thanks, Bob M format>conditional format>formula =mod(row(),2=0) format as desired and copy where desired  SignatureDon Guillett SalesAid Software donaldb@281.com > Is it possible to shade every other row on an existing spreadsheet without > manually shading? This would make it easier to read a list across the row. > > Thanks, > Bob M =mod(row(),2=0) Where do I enter this? It is asking me for cell value,etc. Probably a basic question. Thanks, Bob > format>conditional format>formula > =mod(row(),2=0) [quoted text clipped - 5 lines] > > Thanks, > > Bob M This web page of Chip Pearson should explain: http://www.cpearson.com/excel/banding.htm SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > =mod(row(),2=0) Where do I enter this? It is asking me for cell value,etc. > Probably a basic question. [quoted text clipped - 13 lines] > > > Thanks, > > > Bob M That should help. Thanks, Bob M > This web page of Chip Pearson should explain: > [quoted text clipped - 16 lines] > > > > Thanks, > > > > Bob M format refers to the format on the toolbar at the top of your worksheet conditional formattin is an option formula is is an option in the left box It's pretty self-explanatory unless you went to college at Texas A & M. SignatureDon Guillett SalesAid Software donaldb@281.com > =mod(row(),2=0) Where do I enter this? It is asking me for cell value,etc. > Probably a basic question. [quoted text clipped - 13 lines] > > > Thanks, > > > Bob M What have you got against Texas A&M Don? I went to Michigan, so I personally don't have any bias, pro or con, about Texas. Did they beat the hell out of *your* alma mater?<bg> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > format refers to the format on the toolbar at the top of your worksheet > conditional formattin is an option [quoted text clipped - 18 lines] > > > > Thanks, > > > > Bob M It's just a running joke kind of thing between the University of Texas (my school) and A & M. We "fondly" call them "aggies". They don't usually beat us. BTW. I have an aggie daughter in law so they aren't all bad. <G> SignatureDon Guillett SalesAid Software donaldb@281.com > What have you got against Texas A&M Don? > I went to Michigan, so I personally don't have any bias, pro or con, about [quoted text clipped - 24 lines] > > > > > Thanks, > > > > > Bob M |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.