Conditional highlighting based on the value of multiple cells

rogueakula

New Member
Joined
Apr 23, 2018
Messages
10
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
HostUser
host1user1
host1user2
host2user1
host2user2
host3user3

<tbody>
</tbody>

Sheet 2
HostUser
host1user1
host2user2
host3user3

<tbody>
</tbody>

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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,317
Office Version
365
Platform
Windows
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
 

Forum statistics

Threads
1,077,991
Messages
5,337,591
Members
399,156
Latest member
RaudMees

Some videos you may like

This Week's Hot Topics

Top