I have 1 or 2 questions, depending on solutions.
I have data like 001.1, 003.1, 005.1... in cells. Then I have cell with data like "001.1|005.1". What I want to do, if it is possible - I want to compare these single values with unseparated values and if some of the single values is included in that string, then highlight it.
One possible solution (which is not what I really want, because of one extra row of values) is to do Text To Column, with separator "|" and then with conditional formatting compare that single values with that result of TextToColumn.
My question is: Is it possible somehow, to compare that single values (E2 = "001.1" etc.) directly with that unseparated values (E11 = "001.1|003.1")? [This is my prefered solution]
Or if NOT, could you help me with writing custom function for Text To Column in VBA?
Here is picture of what I have.
E2:E7 = single values
E11 = unseparated string
G11, H11, I11 = result of Text To Column
window in the right = conditional formatting with custom formula "=OR(E2=$G$11:$I$11)" to compare E2:E7 with G11:I11
Thank you very much.