Conditional Formatting based on certain values within cells

[furnitureguy1]

Hello, I have an employee vacation worksheet where I need cells to become highlighted if two or more people in the same group are taking the same days off. One cell may contain 1,2,3,4 and the other may contain only 3...but since they both share the number 4 I need them both to highlight red. I have diagrammed what I am talking about below.

Thank you in advance for your help!

Randy	1,2,3,4
John
Beth	3
Billy	5
Dan

<tbody>
</tbody>

 

[lrobbo314]

Sure. Send it to robertlego@gmail.com