Check Manually Inputted Text in Cell Range Contains Text from Several Validation Dropdown Lists

[bearwires]

I have manual inputted text strings in cell ranges:

B104:B125
B132:B175

There are validation dropdown Lists located in the following ranges:

B200:B212
D200:D212

B221:B231
D221:D231

The drop down lists could be 1 text string in 1 cell or 1 text string in every cell in the specified ranges.

I would like to check that the manually inputted text that is typed into cells B104:B125 & B132:B175 contains all the text strings selected from the validation dropdown lists.

If it does contain all items in the dropdown lists, then continue with rest of the VBA code I have to hide cells.

If it doesn't contain all items in the dropdown lists, popup a message showing a list of items from the dropdown list not included in the manually inputted text and prompt user to rectify.

Is this possible and can anyone help me out to make it happen?

Thanks