troubleshooting Question

excel query

Avatar of Umesh Kadam
Umesh Kadam asked on
Microsoft ExcelVisual Basic ClassicMicrosoft Office
3 Comments1 Solution121 ViewsLast Modified:
Hi,

Need help to create formula to color single number from Cell B which Matches from Cell A.
Cell B will be having many numbers in it with separated by coma (;) symbol.

Help will be appreciated for this.

Cell A       Cell B
14               13,14,21,22,23
27               16,27
28               16,17,27,28,29
16               16,27,28
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros