Conditional highlighting based on the value of multiple cells

rogueakula

New Member
Joined
Apr 23, 2018
Messages
13
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
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,824
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
 

Watch MrExcel Video

Forum statistics

Threads
1,089,875
Messages
5,410,914
Members
403,333
Latest member
SH2020

This Week's Hot Topics

Top