rogueakula
New Member
- Joined
- Apr 23, 2018
- Messages
- 19
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
<tbody>
</tbody>
Sheet 2
<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
Sheet One
Host | User |
host1 | user1 |
host1 | user2 |
host2 | user1 |
host2 | user2 |
host3 | user3 |
<tbody>
</tbody>
Sheet 2
Host | User |
host1 | user1 |
host2 | user2 |
host3 | user3 |
<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