 |
 | 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 / Worksheet Functions / March 2006VLOOKUP
Hi, I want to do a lookup function but i don't know how to go by it. I have 2 worksheets. I need for Sheet1 to look for some records in Sheet2. If a record on sheet one finds a matching record on Sheet2, Then the record on Sheet1 would be colored coded in Red. I hope I explained this correctly. Use format>conditional formatting>formula is =COUNTIF(MyRange,B1)>0 where B1 in sheet is the cell you check if it occurs in sheet you need to name the range you are checking in sheet or else conditional formatting will not work  SignatureRegards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon > Hi, > [quoted text clipped - 4 lines] > > I hope I explained this correctly. |
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
|
©2009 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.