Finding a number in a range from 1 cell

[Russk68]

Hello all,

I have a column with numbers and each row can contain a # or #># or #/#/#.(101 or 101>105 or 103/106/119)

I also have another column and each row has only 1 number.

For example:
Column A can only contain 1 number in each cell, lets say 103 in A1.
Column B can contain a number or ranges as noted above, lets say 101>105 in B15

I want to use conditional formatting in column A to indicate if 103 is found anywhere in column B.

Possible?

Thanks!

Russ

 

[Peter_SSs]

All good news. Thanks for letting us know.