 |
 | 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 / General Excel Questions / May 2007background-color every second row
am looking for a quick way to background-color every second row grey. So for if example I have used rows 3-76, I want to background colour every 2nd rows 4,6,8,10,12,14,16,18,20,22,24,26,28,30...76 Right now I need to left click and hold ctl button to manually highlight them all, then click on the grey background color fill tool. But maybe there is an easier method! Thanks Select the range you want to colour and then: Format|conditional format|formula is| =MOD(ROW(),2)=0 and then select your colour and click OK. Mike > am looking for a quick way to background-color every second row > grey. [quoted text clipped - 8 lines] > > Thanks See http://www.xldynamic.com/source/xld.CF.html#rows  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > am looking for a quick way to background-color every second row > grey. [quoted text clipped - 8 lines] > > 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.