I am using this way to sort text in a column - Conditional formating>Highlight cells rules>Text that contains... but when i try to sort text that contains two or more words, which are not in order i have a problem because the sort function doesn't highlight the text in the cells which is not in the specified order. For example, if i want to highlight all cells that contain the words "real music" it won't highlight the cells that have some words between these words. Like this words "real rock music", "real classic music" - it won't highlight them.
Is there any way to highlight the cells that contain the words "real music" but they are in different order?
Thanks!
Bookmarks