 |
 | 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 / December 2007A way to modify pattern applied to every other row
Hello, I do see how to use the autoformat and List 1 to produce shading for every other row. Is there a way to modify the color of the shading? Thanks very much in advance bartmacl Using List1 from the Styles dialog you will find that inserting/deleting rows or sorting/filtering will mess up the alternate row formatting. If you use Conditional formatting you can choose the color and the banding will hold through the above functions. Select a gaggle of rows then Format>Conditional Formatting>Formula is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Format to a color you like and OK your way out. Gord Dibben MS Excel MVP >Hello, I do see how to use the autoformat and List 1 to produce shading for >every other row. >Is there a way to modify the color of the shading? >Thanks very much in advance > >bartmacl Thanks very much! > Using List1 from the Styles dialog you will find that inserting/deleting > rows or [quoted text clipped - 19 lines] >> >>bartmacl
|
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.