Convert Text into multiple rows and search result in next sheet

Hi,

Could some one help me with a vba script to convert the text in a cell(split considering "Space" as delimiter) into multiple Rows and Single column & the resultant row's(A1:A7000) values need to be searched in Column(B) of another sheet,if the search result is false then the value in the row need to be highlighted in red.

I am able to split the values in one column into mutiple rows,but need to have all the resultant values in a single column.
i,e,.

I am able to split it as below:

Column A	Column B	Column C
A AA	A	BB
BB BBAB	AA	BBAB

But I want it to be

Column A	Column B
A AA	A
BB BBAB	AA
	BB
	BBAB

for second situation - search
I could search based on the values by using Vlookup() function,but unable to highlight when search result is false.

ex:

if the search string "ACB" in Sheet1 is not available in the sheet2, then value "ACB" should be changed into red.


Someone could please help me with your suggestions.

Thanks in advance...........