In each cell from A1:A10 I have a concatenated text string that contains both a number and a word, e.g. "84 Apple". I want to apply conditional formatting so that if any of the cells contain a value greater than or equal to 80 my formatting applies. I am struggling with the formula needed to apply this though.
Any help would be greatly appreciated!
Bookmarks