privatemoon
New Member
- Joined
- Feb 15, 2013
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Is there a way to compare two columns and highlight all the items in column A that can be found in column B?
For example:
Col A
abc@gmail.com <-highlight
ghs@gmail.com
yag@gmail.com
yur@gmail.com <-highlight
Col B
yst@gmail.com
yur@gmail.com
abc@gmail.com
tri@gmail.com
For example:
Col A
abc@gmail.com <-highlight
ghs@gmail.com
yag@gmail.com
yur@gmail.com <-highlight
Col B
yst@gmail.com
yur@gmail.com
abc@gmail.com
tri@gmail.com