Conditional highlighting based on the value of multiple cells

[rogueakula]

I have a large list of items that I want to verify. There are two sheets, one with the raw data and the second with a list of items. Set up kind of like this:

Sheet One
[TABLE="width: 500"]
<tbody>[TR]
[TD]Host[/TD]
[TD]User[/TD]
[/TR]
[TR]
[TD]host1[/TD]
[TD]user1[/TD]
[/TR]
[TR]
[TD]host1[/TD]
[TD]user2[/TD]
[/TR]
[TR]
[TD]host2[/TD]
[TD]user1[/TD]
[/TR]
[TR]
[TD]host2[/TD]
[TD]user2[/TD]
[/TR]
[TR]
[TD]host3[/TD]
[TD]user3[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Host[/TD]
[TD]User[/TD]
[/TR]
[TR]
[TD]host1[/TD]
[TD]user1[/TD]
[/TR]
[TR]
[TD]host2[/TD]
[TD]user2[/TD]
[/TR]
[TR]
[TD]host3[/TD]
[TD]user3[/TD]
[/TR]
</tbody>[/TABLE]

What I would like to do is highlight the user in sheet one based on the username and host matching in sheet 2. I am sure that I can do this but it is more complicated than then a simple conditional highlight. Thank you guys so much for your help!

-Josh

 

[Fluff]

You can do it with conditional formatting.
On sheet1 select B2:B & last row > CF > New rule > use a formula > enter
=INDEX(Sheet2!$A$2:$A$4,MATCH(B2,Sheet2!$B$2:$B$4,0))
Select format > OK