 |
 | 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 2005Alternate Colors
Is there a way that if I select a range of lets say 140 rows and then want to change the colors from white to something else that I could make it where one row is one color while the next is another and then soforth with a combination of maybe 2-4 colors or something. Even just alternating between just 2 colors? If not built in, then is there a trick or script or something that someone has that could assist with something like this? Would be much appreciated. Thanks. Hi Mark One way would be conditional formatting. Select the whole sheet by pressing Ctrl+A Format>Conditional Formatting>select Formula is from dropdown In White pane type =MOD(ROW(),2)=0 for every other row Format choose Patterns then the colouring you want Click Add and repeat for =MOD(ROW(),3)=0 for every third row, with a different colour. Regards Roger Govier > Is there a way that if I select a range of lets say 140 rows and then want > to change the colors from white to something else that I could make it where [quoted text clipped - 3 lines] > that someone has that could assist with something like this? Would be much > appreciated. Thanks. See http://www.xldynamic.com/source/xld.CF.html#rows  SignatureHTH Bob Phillips (remove nothere from email address if mailing direct) > Is there a way that if I select a range of lets say 140 rows and then want > to change the colors from white to something else that I could make it where [quoted text clipped - 3 lines] > that someone has that could assist with something like this? Would be much > appreciated. Thanks. |
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.