drgregharris
New Member
- Joined
- Jun 9, 2015
- Messages
- 2
I want to highlight cells which do NOT contain text from two different cells. Here's what I have.
A B C D
1 Jason Jason - Chris Jason Mark
2 Chris Chris Jason - Chris John
In this example, the reference cells are A1 and A2. If the cells do not contain either Jason, Chris, or Jason - Chris, they should be highlighted. Here cells B2, C1, and D2 should be highlighted. Can anyone help me out?
Thanks
Greg
A B C D
1 Jason Jason - Chris Jason Mark
2 Chris Chris Jason - Chris John
In this example, the reference cells are A1 and A2. If the cells do not contain either Jason, Chris, or Jason - Chris, they should be highlighted. Here cells B2, C1, and D2 should be highlighted. Can anyone help me out?
Thanks
Greg
Last edited: