Umesh Kadam
asked on
excel query
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A solution
you cannot do it with a formula but VBA
Open in new window
Regards