Loop to test 2 matches using 4 variables

[dems]

Hi guys,

I am trying to test for 2 matches based on 4 variables/columns (ie. B = C and D = E) and then colour the relevant row.

I felt I could use the same methodology from the code I developped to colour the row to a single match (B = C), but I am not having much success as such would be extremely grateful for some suggestions.

The original thread to match one variable is:
http://www.excelforum.com/excel-prog...in-a-loop.html

Adapted code with little success:

Please Login or Register  to view this content.

Your time is appreciated!

[rwgrietveld]

How about this

Please Login or Register  to view this content.

[dems]

Hi rwgrietveld,

Unfortunately this code doesnt return me any results.

Perhaps should have mentioned that column B is ~2,000 rows whilst column C is ~65,000 rows (as are D and E respectively), which is why i felt i would require a nested loop.

I have attached an exmaple of what I am trying to accomplish. Hopefully this will do a better job explaining that I have done.


cross-post reference to other thread http://www.mrexcel.com/forum/showthr...28#post2163328

[teylyn]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!